Counting Rows in a Matrix

[FU]

Hi all,

I am trying to create a visual which counts the number of rows that are displayed on the matrix shown below. 

Please note I have the measure in the matrix filters to only show me rows that have different values in each date column (hopefully clearly shown)

Does anyone know how I can count the number of rows showing?

Pbix file: https://we.tl/t-vd5jYugdD6

[v-jingzhang]

Hi @FU

If I understand it correctly, you can create the following measure and display it in a card visual. 

Count of Rows = 
VAR _table = SUMMARIZE('Project Risks Query-xxx','Project Risks Query-xxx'[Risk ID],'Project Risks Query-xxx'[Attribute],"Distinct_Count", 'Distinct Measure'[DistinctCount])
RETURN
COUNTROWS(FILTER(_table,[Distinct_Count] > 1))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[FU]

@amitchandak