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 wonder if anyone ever needs to calculate the percentage of sales/cost/production of the selected customer/style/group over the grand total (selected and unselected).
In the example below:
For sales date from 1/1/2018 to 1/30/2018, customer AAA and BBB should count for 75% of total sales (2160/2880)
The end result would be a measure that can be put in an enhanced text display card showing:
So in short, the numerator should interact with the filter while the denominator should not interact with the filter.
I could not find a post with a similar question and have tried several ways but no luck so far.
I have created a test file but I'm not sure how to upload it... here is a link:
https://1drv.ms/u/s!AioBq1-tCi_vlVYHUpXsu5-Mc4Hh
I would really appreciate the help!
Thank you!
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
There are two ways to this problem:
1. Measure = [Quantity sold]/CALCULATE([Quantity sold],ALLEXCEPT('Table','Table'[Sales Date]))
2. Measure = [Quantity sold]/CALCULATE([Quantity sold],ALL('Table'[Style]),ALL('Table'[Customer])) - contributed by Ashish_Mathur
Thank you!!
There are two ways to this problem:
1. Measure = [Quantity sold]/CALCULATE([Quantity sold],ALLEXCEPT('Table','Table'[Sales Date]))
2. Measure = [Quantity sold]/CALCULATE([Quantity sold],ALL('Table'[Style]),ALL('Table'[Customer])) - contributed by Ashish_Mathur
Thank you!!
Hi,
You may download my PBI file from here.
Hope this helps.
Thank you for sharing this!
Thank you so much Ashish!
You are welcome.
My friend at work tried this:
= SUM('Table'[Sales Qty]) / CALCULATE(SUM('Table'[Sales Qty]),ALL('Table'))
but this ends up ignoring the date filter as well...
Anyone know how to make it include everything except the date?
Thank you!
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |