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.
Go to Solution.
Hi @DarylM ,
You can try the following measure:
item #'s less than or equal to 5 =
VAR __rank =
ADDCOLUMNS ( 'Table', "rank", [Rankx Measure] )
CALCULATE ( DISTINCTCOUNT ( 'Table'[Item #] ), FILTER ( __rank, [rank] <= 5 ) )
Results are as follows:
Here is a demo, you can try it:
Community Support Team _ JoeyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
If 'Rank<5' is a calculated column you could place this measure in a card visual:
CALCULATE ( DISTINCTCOUNT ( Table1[Item #] ), Table1[Item #] <= 5 )
Please mark the question solved when done and consider giving kudos if posts are helpful.
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.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!