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.
I'm trying to create a measure which counts whether a customer contributed to the top 80% of the revenue.
At the moment I have the following data:
rank | debtor | Revenue | Revenue cumulative | % of total revenue | < 80%
1 a 350 350 54% 1
2 b 300 650 100% 0
Total 650
Less then 80% is a measure created by using the switch function
Solved! Go to Solution.
Hi @Anonymous ,
please try this:
Amount = SUMX ( VALUES ( 'TableName'[debtor]), [< 80%])
BR
Timo
Hi @Anonymous
just add a card with the Measure "< 80%".
Or understand you wrong?!
BR
Timo
Edit: You are able to select the SUM for the Measure "<80%"
Hi @Anonymous ,
Unfortenately thats not working. A card will show me the value 1, as it will ignore all the different debors and shows me the sum of all the revenues divided by the cumulative revenue. The outcome will be 100%, so the card will show me the value 1.
Hi @Anonymous ,
I try to reproduce your report/data. Are "Revenue cumulative" and "% of total revenue" custom columns or custom measures or are they part of the import?
Do you import a file or is it a direct query?
BR
Timo
Hi @Anonymous ,
these are all custom measures. I don't use import, i'm working with Direct Query!
Kind Regards,
Annabel
Hi @Anonymous ,
please try this:
Amount = SUMX ( VALUES ( 'TableName'[debtor]), [< 80%])
BR
Timo
@Anonymous Works perfect!!! Thanks!! 🙂
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |