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.
Hi all,
Kindly assist me with with a Top N and a Bottom N measure for my YTD measure:
I have a list of Major areas and the YTD Sales or MTN Gross Conns.
I would like to Rank or get the Top 10 and Bottom 10 Major Areas based on the MTN Gross Conns measure.
Please assist:)
Solved! Go to Solution.
@Kratos_ZA Same thing but in the "Show items" dropdown choose Bottom instead of the default Top.
@Kratos_ZA So one method would be to expand the Filters pane. Select the drop down for MAJOR_AREA_NAME and change to Top N. Then enter how many and then drag your MTN Gross Cons measure into the By value field well.
@Greg_Deckler Thanks buddy! And the Bottom N? Also looking at bottom 20 Major Areas?
@Kratos_ZA Same thing but in the "Show items" dropdown choose Bottom instead of the default Top.
Thanks buddy! And the Bottom N? Also looking at bottom 20 Major Areas?
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |