Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all,
I have a percentage difference volume measure for - 1 year.
my dataset contains a number of locations also. how would i go about finding the difference between the two.
Solved! Go to Solution.
Hey @phyconia ,
how do you want to analyze?
If you want one card to only return the value for the Zone-Slicer, then use a card and change the interaction with the second visual and do the same for the VS-Slicer and the second card:
Change how visuals interact in a report - Power BI | Microsoft Docs
If you want to get a result in a measure then calculate the value for the first slicer, use ALL(mySlicerTable[VS]) to remove the filter from the second slicer and then divide by the measure of the second slicer and use ALL(mySlicerTable[Zone]).
Hey @phyconia ,
then you can do everything in one measure, like I proposed in the second appraoch.
Something like this should do it:
Percentage =
VAR vMeasure1 = CALCULATE( [result of % car diff from Zone], ALL( slicerTable[VS] ) )
VAR vMeasure2 = CALCULATE( [result of % car diff from VS], ALL( slicerTable[Zone] ) )
RETURN
DIVIDE(
vMeasure1,
vMeasure2
)
Hey @phyconia ,
how do you want to analyze?
If you want one card to only return the value for the Zone-Slicer, then use a card and change the interaction with the second visual and do the same for the VS-Slicer and the second card:
Change how visuals interact in a report - Power BI | Microsoft Docs
If you want to get a result in a measure then calculate the value for the first slicer, use ALL(mySlicerTable[VS]) to remove the filter from the second slicer and then divide by the measure of the second slicer and use ALL(mySlicerTable[Zone]).
Im sorry, I didn't make it easy to understand to be honest.
What i want to do is get the result of % car diff from Zone and the result of % car diff from VS and get the percentage difference between the 2 as a new measure shown in a single card.
Hey @phyconia ,
then you can do everything in one measure, like I proposed in the second appraoch.
Something like this should do it:
Percentage =
VAR vMeasure1 = CALCULATE( [result of % car diff from Zone], ALL( slicerTable[VS] ) )
VAR vMeasure2 = CALCULATE( [result of % car diff from VS], ALL( slicerTable[Zone] ) )
RETURN
DIVIDE(
vMeasure1,
vMeasure2
)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |