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 am trying to extract the total sales amount for the top 20% clients. I am able to manage this per sales representative manually, however i would like to change the figures automatically by selecting a sales representative in a slicer.
Currently I ranked the clients using a RANKX DAX measure, then I created a measure that counts the amount of clients * 0,20 to get the rank number of the 20% best clients (separate visualisation), at last i enter this in the visual level filter of the rank measure ( is less than x ) in a table visualisation.
By doing this i am able to achieve the results I want, however it isn't efficient at all. This brings me to my question if it is possible to solve this issue with DAX?
Thanks
Solved! Go to Solution.
Hello,
I have done the same analysis. This link is a good starting point: http://community.powerbi.com/t5/Desktop/Pareto-80-20-calculation-for-items-making-up-80-of-Sales/td-...
It works fine.
But now I am trying to implement month and year filtering and some problems emerge.
Todor
Hi,
Just in case this could be a "temporary" solution, I use the top N filters 😛
Hello,
I have done the same analysis. This link is a good starting point: http://community.powerbi.com/t5/Desktop/Pareto-80-20-calculation-for-items-making-up-80-of-Sales/td-...
It works fine.
But now I am trying to implement month and year filtering and some problems emerge.
Todor
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |