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.
Hello,
I am working on a dashboard that will serve to compare information for two different systems at work that should have the same information and need to measure the variation; however, as calculation is the same and I am using a matrix, the values for the measures are duplicated and I just one to leave one, the other portion could be blanked out.
Code and screenshot below:
Any help on this?
Measure code:
Solved! Go to Solution.
Try this measure. I rewrote it with variables for readability.
% Variation Dec-2020 =
VAR vKeyFigure =
MAX ( Data[Key Figure] )
VAR vDepDemand =
CALCULATE ( SUM ( Data[Dec-2020] ), Data[Key Figure] = "Dependent Demand" )
VAR vSamurai =
CALCULATE (
SUM ( Data[Dec-2020] ),
Data[Key Figure] = "Samurai Actuals/Gross Fcst"
)
VAR vResult =
DIVIDE ( vDepDemand, vSamurai ) - 1
RETURN
IF ( vKeyFigure = "Dependent Demand", BLANK (), vResult )
Proud to be a Super User!
Hi @Chava1881
If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!
If not, please kindly elaborate more.
Try this measure. I rewrote it with variables for readability.
% Variation Dec-2020 =
VAR vKeyFigure =
MAX ( Data[Key Figure] )
VAR vDepDemand =
CALCULATE ( SUM ( Data[Dec-2020] ), Data[Key Figure] = "Dependent Demand" )
VAR vSamurai =
CALCULATE (
SUM ( Data[Dec-2020] ),
Data[Key Figure] = "Samurai Actuals/Gross Fcst"
)
VAR vResult =
DIVIDE ( vDepDemand, vSamurai ) - 1
RETURN
IF ( vKeyFigure = "Dependent Demand", BLANK (), vResult )
Proud to be a Super User!
This works perfectly, 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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |