Count the Number of Rows where the MAX or TOPN equals a specific number

[Anonymous]

I need to create a measure that calculates how many unique items in a table have a MAX value of a certain number. I am trying to put the results inside of a Card visual.

As an example, I am wanting a count of the unique IDs in the following table that have a max status of 3, which should just be a count of 1:

ID        Status

1001       1

1002       2

1001       3

1002       1

[v-xicai · Accepted solution]

 Hi @Anonymous 

You can create measure Count_Max to meet your demand.

Count_Max = CALCULATE(DISTINCTCOUNT(Table1[Status]),FILTER(ALLSELECTED(Table1[Status]),Table1[Status]=MAX(Table1[Status])))

Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EePkU0bR6bNFqU3SZcJ5Z14B60swKEmgtNy5Wj9G9ME2Qw?e=ee9Oe2

Best Regards,

Amy

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