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 Experts
How would you rank products based on the values in the data set. See images below i have ranked each product based on the values for that products so each product group has its own ranking. (if that makes any sense).
Solved! Go to Solution.
Refer
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
Ranking by Sub Category = RANKX ( FILTER( ALL( 'Table'[Category], 'Table'[Sub Category] ), 'Table'[Category] = MAX('Table'[Category]) ), CALCULATE(SUM('Table'[My Value])) )
Hi @Anonymous
Create columns
rank = RANKX(FILTER('Table','Table'[product]=EARLIER('Table'[product])),[value],,ASC,Dense)
THanks you maggie and god bless...
Refer
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
Ranking by Sub Category = RANKX ( FILTER( ALL( 'Table'[Category], 'Table'[Sub Category] ), 'Table'[Category] = MAX('Table'[Category]) ), CALCULATE(SUM('Table'[My Value])) )
Hi Amit
i need to add this as calculated column....into a table..
silly question whats Category and sub Category from my example...
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 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |