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 everyone,
I have the few Created Measures in my Database:
- StoreRank = RANKX(ALL(Table[Store Code],Table[Store Name]),CALCULATE(SUM(Table[Sales Volume])),,DESC)
- ProductRank = RANKX(ALL(Table[Product Code],Table[Product Name]),CALCULATE(SUM(Table[Sales Volume])),,DESC)
I need to know:
1. When I Built a Table by Columns Store Code, Store Name, Sales Volume and Store Rank, how not to show any Ranks in the Total at the bottom, at the moment I get a number - 1 rank for the top store and also the total at the bottom also is given a Number - 1 Rank I want to make it blank in there.
2. If I populated a Table with Product details and chose to put in one column the Store Rank, it shows Rank - 1 for all the products, I want to make it Blank as well because I didnt chose any columns related to Store in this table.
Solved! Go to Solution.
For your first question, you can use HASONEFILTER to detect totals/subtotals
Something like this
- StoreRank = IF ( HASONEFILTER ( Table[Store Code] ), RANKX ( ALL ( Table[Store Code], Table[Store Name] ), CALCULATE ( SUM ( Table[Sales Volume] ) ), , DESC ) )
Did I ask something not logical to do in Power BI ?
For your first question, you can use HASONEFILTER to detect totals/subtotals
Something like this
- StoreRank = IF ( HASONEFILTER ( Table[Store Code] ), RANKX ( ALL ( Table[Store Code], Table[Store Name] ), CALCULATE ( SUM ( Table[Sales Volume] ) ), , DESC ) )
can you help me on another issue please ?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |