Duplicated Calculation / Leave only one row of data on measures

[Chava1881]

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:

% Variation Dec-2020 = (DIVIDE(

CALCULATE(

SUM(Data[Dec-2020]),

Data[Key Figure] = "Dependent Demand"

),

CALCULATE(

SUM(Data[Dec-2020]),

Data[Key Figure] = "Samurai Actuals/Gross Fcst"

)

)) -1

[v-diye-msft]

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.

[DataInsights · Accepted solution]

@Chava1881,

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 )

[Chava1881]

This works perfectly, thank you!!