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 have 3 calculations:
For the numerator, it displays the correct value (spend amount based on the combination of selected slicers and selected category/axis on the graph, see image below [numerator should be equal to spend amount in card]).
For the denominator, the value it should return is the sum of amount by selected slicer (could be multiple slicer (denominator should be equal to spend amount of selected slicers (release date and/or purchase type)), regardless of what is selected in the bar graph category(axis. )see image:
When I select a graph the denominator displays the wrong value (denominator should remain 275BN), resulting to wrong percentage. See image:
The correct value for denominator only appears if I only choose one of the slicer (either purchase type or release date). It doesnt work if I choose both.
Here's the formula I used for denominator:
Denominator =
CALCULATE(SUM('Spend Analysis'[PO_Amount]),
ALL('Spend Analysis'[Material Group]),
ALLSELECTED('Spend Analysis'[Date]))
I also tried this and nothing happened:
Denominator =
CALCULATE(SUM('Spend Analysis'[PO_Amount]),
ALL('Spend Analysis'[Material Group]),
ALLSELECTED('Spend Analysis'[Date]),
ALLSELECTED('Spend Analysis'[Purchase_Type])
Hi,
Try this
=CALCULATE(SUM('Spend Analysis'[PO_Amount]),ALL('Spend Analysis'[Material Group]))
still not working,
There seems to be some issue with the relationships.
i'm only using one table so no relationship was made on my date. I tried everything but nothing work for the function ALL or ALLSELECTED
Hi,
Share the link from where i can download your PBI file.
Here's the link:
Would really appreciate the help
https://1drv.ms/u/s!Ah4rAyDWhMzAtlWGVcOQKM-LJVNR?e=TzSvgf
I am just way too confused. Just too many visuals there. I do not know in which visual, what result do you want to see.
Hi,
This one works
Percent Total Spend denominator = CALCULATE(SUM('Spend Analysis'[PO_Amount]),ALL('Spend Analysis'[Material_Description]))
When i select a bar in the Material Description graph, the figure for this measure does not change.
I used the material description as the sample bar graph filter.
Hi,
Im reattaching the power bi file
please see link: https://1drv.ms/u/s!Ah4rAyDWhMzAtlWGVcOQKM-LJVNR?e=Am66Oz
the denominator still changes when: slicer, release date, and bar graph was selected.
Hi,
Use the ALL similarly for all columns which should not impact the calculation.
Hi, please see attach image. Please use percent share (not overall percent share) beside spend amount.
Percent Share = Numerator / Denominator *100 (as seen in the image, numerator card and denominator card).
Material group is the one that im using as a filter (any bar graph below the cards)
Hi, this didn't help. It only mimicked the behavior of the numerator.
Hi @Anonymous
How about this.
Denominator = CALCULATE( SUM( 'Spend Analysis'[PO_Amount] ), ALL( 'Spend Analysis' ), VALUES( 'Spend Analysis'[Date] ), VALUES( 'Spend Analysis'[Purchase_Type] ) )
it still didn't work once i filtered through bar graph
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |