How to count rows of the visual table

[Maahmohammed]

How to count rows of a visual table?

[v-nuoc-msft · Accepted solution]

Hi @Maahmohammed 

Thank you very much lbendlin for your prompt reply. Allow me to add a few things.

Here's some dummy data

“Table”

Create measures.

Total Count = COUNTROWS('Table')

Total Distinct Count = DISTINCTCOUNT('Table'[Category])

Group By Count = 
CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        'Table',
        'Table'[Category] = MAX('Table'[Category])
    )
)

Group By Distinct Count = 
CALCULATE(
    DISTINCTCOUNT('Table'[Category]),
    FILTER(
        'Table',
        'Table'[Category] = MAX('Table'[Category])
    )
)

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Examine the DAX code that is used to render the visual (use the Performance Analyzer to get to the query code).

Note that these queries are paged, so the default answer would be "501" or similar according to the TOPN limiter.