Year over year change in type string calculation

Hey apelleti,

Add an table visual and put the 'ID' in it.

Then create a measure that assigns the label to the 'ID'.

Measure = 
VAR _2022 =
    CALCULATE ( 
        SELECTEDVALUE ( 'Table'[Result] ),
        'Table'[Year] = "2022"
    )
VAR _2021 =
    CALCULATE ( 
        SELECTEDVALUE ( 'Table'[Result] ),
        'Table'[Year] = "2021"
    )
VAR _result =
    SWITCH ( 
        TRUE,
        _2022 = "1" && _2021 = "1", "No change – result 1",
        _2022 = "2" && _2021 = "2", "No change – result 2",
        _2022 = "2" && _2021 = "1", "Change – increase",
        _2022 = "1" && _2021 = "2", "Change – decrease"
    )
RETURN
    _result

Place the measure in the table visual for the desired result.

For your second request, we need to add a new table. I named this one 'Table (2)'.

YoY

Place this new table in a table visual.

Create a second measure to calculate the number.

Measure 2 =
SUMX (
    'Table (2)',
    COUNTROWS (
        FILTER ( DISTINCT ( 'Table'[ID] ), [Measure] = EARLIER ( 'Table (2)'[YoY] ) )
    )
)

Finally, place the measure in the visual.