Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to get difference between two columns in Matrix based on slicer selection of Year in Power Bi

  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Here you go https://www.dropbox.com/t/sMyzwonHckNHvdKX
    Original Measure code remains the same

    Measure = COUNTROWS ( DISTINCT ('Table'[Value] ) )

    New Measure code is

    Measure1 = 
    VAR MaxYear = MAX ( 'Table'[Year] )
    VAR MinYear = MIN ( 'Table'[Year] )
    VAR MaxYearValue =
        CALCULATE ( 
            [Measure],
            'Table'[Year] = MaxYear
        )
    VAR MinYearValue =
        CALCULATE ( 
            [Measure],
            'Table'[Year] = MinYear
        )
    VAR Difference = MaxYearValue - MinYearValue
    VAR Result =
        SWITCH (
            TRUE,
            NOT HASONEVALUE ( 'Table'[Year] ), Difference,
            COUNTROWS ( ALLSELECTED ('Table'[Year] ) ) = 1, BLANK(),
            [Measure]
        )
    RETURN
        Result