Desktop

[MartijnNL]

Hello,

I have a dataset 'Source'  that has several variables such as KPI name, period and the value and also a version. I want to compare 2 versions and show the delta between them by have 2 filters in the top to select a version.

I have loaded the source and then created 2 other tables with all possible versions:

I have managed to create both filters and have independent visuals to show the values of the filter, but the delta is not possible:

No. 1: Using measures like 

CALCULATE (SUM (Source[Waarde]);

    FILTER (ALLEXCEPT ( 'Source'; 'MainVersion' );

        Source[Versie] = MainVersion[MainVersionSelected]

    ))

  the delta is calculated but I want to be able to filter also on, KPI name, month and year and that is not possible this way.

No. 2:  Using measures like 

SUMX(FILTER(Source; Source[Versie] = MainVersion[MainVersionSelected]);Source[Waarde])

     the visuals show the correct figure but the delta is not calculated.

Included pbix:

PBIX link

Any ideas?

[v-jiascu-msft · Accepted solution]

Hi @MartijnNL,

Try this one, please. We only need to clear the unwanted filters.

Measure =
CALCULATE ( SUM ( Source[Waarde] ), ALL ( SecondVersion ) )
    - CALCULATE ( SUM ( Source[Waarde] ), ALL ( MainVersion ) )

Best Regards,
Dale

[v-jiascu-msft · Accepted solution]

Hi @MartijnNL,

Try this one, please. We only need to clear the unwanted filters.

Measure =
CALCULATE ( SUM ( Source[Waarde] ), ALL ( SecondVersion ) )
    - CALCULATE ( SUM ( Source[Waarde] ), ALL ( MainVersion ) )

Best Regards,
Dale

[MartijnNL]

@v-jiascu-msft Thank you this is exactly what I was looking for. The measure seems to be so simple I will study the ALL functions a bit more to understand how to use them in the future. Thanks again.