Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! 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] ) RETURN CALCULATE ( DISTINCTCOUNT ( 'Table'[Item #] ), FILTER ( __rank, [rank] <= 5 ) )
Results are as follows:
Here is a demo, you can try it:
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.
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:
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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |