0

How to add a CountRows Functionality in Pyramid

Hi Pyramid team,

I would like to request the addition of CountRows functionality in Pyramid, similar to the feature in DAX (Power BI). Currently, we need a function that can count the number of rows in a table using only the table's name. This functionality is extensively described here.

The CountRows function in DAX allows users to count all rows in a table without specifying columns or conditions, unlike the existing COUNT function in Pyramid, which requires specifying columns or conditions for counting. This new functionality would simplify queries and reports, making it easier to perform row count operations directly from table names.

Here are the links describing the COUNT function in Pyramid: 1, 2.

Thank you!

3 replies

null
    • "making the sophisticated simple"
    • AviPerez
    • 3 mths ago
    • Reported - view

    Simply add a count measure to any column in a table. 

      • TKH_TKH
      • yesterday
      • Reported - view

       Thank you for the response! I just wanted to clarify - adding a count measure seems to require specifying a column. However, I’m looking for functionality similar to CountRows in DAX, where it’s possible to count rows for an entire table without specifying any columns or conditions.

      • "making the sophisticated simple"
      • AviPerez
      • 23 hrs ago
      • Reported - view

       Its the same thing.

Login to reply

Content aside

  • Status Answered
  • 23 hrs agoLast active
  • 3Replies
  • 44Views
  • 2 Following