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 would like to know if it is possible to calculate the top N product following two criteria
example top 10 products based on Manager and Region
Also i would like to know how we can have the FLOP 10 of Products (if there is an example why not)
best regards
sli
Solved! Go to Solution.
Hi @SLI ,
Based on my research, there are three ways to get the top ten or bottom n data.
1.You could use the "Top N" filter function in filter type:
https://community.powerbi.com/t5/Desktop/TopN/td-p/131646
2.You could use the dax "TOP N":
https://docs.microsoft.com/en-us/dax/topn-function-dax
https://community.powerbi.com/t5/Desktop/find-top-and-bottow-N-rows-in-table-DAX/td-p/343434
3.Use M languages:
https://community.powerbi.com/t5/Desktop/Top-N-and-Bottom-N-in-single-chart/td-p/145430
Regards,
Daniel He
Hi @SLI ,
Based on my research, there are three ways to get the top ten or bottom n data.
1.You could use the "Top N" filter function in filter type:
https://community.powerbi.com/t5/Desktop/TopN/td-p/131646
2.You could use the dax "TOP N":
https://docs.microsoft.com/en-us/dax/topn-function-dax
https://community.powerbi.com/t5/Desktop/find-top-and-bottow-N-rows-in-table-DAX/td-p/343434
3.Use M languages:
https://community.powerbi.com/t5/Desktop/Top-N-and-Bottom-N-in-single-chart/td-p/145430
Regards,
Daniel He
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |