Apply a Year-Over-Year variation in just one year with multiple years selected

[PwrBI01]

Hi guys,

I have created the following table on Power BI:

And I would like to just show the variation of 2019 over 2018, so the table I want is the next one:

Is there a way to do it?

The Power BI file where you can see it is https://www.dropbox.com/s/spl6zkv56y9slpi/Power%20BI%20problem.pbix?dl=0

Thanks in advance.

[MFelix · Accepted solution]

Hi @PwrBI01 ,

Create a new table with the measures you need:

Measure

Measure
Variation

then add the following measure:

Measure2 =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Filter'[Measure] ) = "Measure", [Measure],
    IF (
        SELECTEDVALUE ( 'Calendar'[Year] )
            = MAXX ( ALLSELECTED ( 'Calendar'[Year] ), 'Calendar'[Year] )
            && SELECTEDVALUE ( 'Filter'[Measure] ) = "Variation",
        FORMAT ( [Variation], "##%" )
    )
)

Now add the columns from the previous table haas an hierarchy in the year column.