How to count rows of the visual table

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.