Count Distinct Items Ranked Less than 5

[DarylM]

Hello, 

I have a project where I need to count the number of items where the Rank is less than or equal to 5. 

Using RANKX I created a ranking for each item, but for the life of me have not been able to figure out how to count the item numbers that rank less than or equal to 5. 

Below in the Rank <5 field is my desired effect if it can be achived. 

Thanks!

[v-joesh-msft · Accepted solution]

Hi @DarylM ,

You can try the following measure:

item #'s less than or equal to 5 =
VAR __rank =
    ADDCOLUMNS ( 'Table', "rank", [Rankx Measure] )
RETURN
    CALCULATE ( DISTINCTCOUNT ( 'Table'[Item #] ), FILTER ( __rank, [rank] <= 5 ) )

Results are as follows:

Here is a demo, you can try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EUUOKDmzbrdFt6VWPB...

Best Regards,

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

[AlB]

Hi @DarylM 

If 'Rank<5'  is a calculated column you could place this measure in a card visual:

Measure =
CALCULATE ( DISTINCTCOUNT ( Table1[Item #] ), Table1[Item #] <= 5 )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[DarylM]

Hi Thanks!

Sorry, I realized that I should have made my comments clearer. 

The example I just created in Excel to show what I am looking for. The RANKX is a measure in Power BI and I a trying to create a measure that will count the item #'s less than or equal to 5.