Forum Discussion

han_rj's avatar
han_rj
Icon for Helper IV rankHelper IV
1 year ago

Nested Calculation item not working

I have created a calculation item for This Year and Prior Year and wanted to calculate Variance for it. But the varaince calculation item is not working  Variance = CALCULATE(SELECTEDMEASURE()...
han_rj's avatar
han_rj
Icon for Helper IV rankHelper IV
1 year ago

Thank You for responding, I tried both ways did'nt work

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

Try

Variance =
VAR ThisYear =
    CALCULATE ( SELECTEDMEASURE (), DATESYTD ( 'Date'[Date] ) )
VAR LastYear =
    CALCULATE (
        SELECTEDMEASURE (),
        DATEADD ( DATESYTD ( 'Date'[Date] ), -1, YEAR )
    )
VAR Result = ThisYear - LastYear
RETURN
    Result