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,
I am currently working on a report comparing revenue between the same product but with different sales environments.
I want to work out the average revenue lost per item and total average overall revenue lost from the one in the worser performing environment, based on the sales in the better performing environment.
I have the total quanity of sales for both categories and total revenue for both.
Is there any measures that could help me with this?
Thanks!
@Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
See if Rank can help
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |