Calculate Delta planning version with planning group segmentation

[theunissenp]

Hi all,

I used the following formula to calculate the delta between to version:

Delta =

VAR SelectedVersion= VALUES(Test[Planning version])

VAR Minvalue= MINX(

    SelectedVersion,

    CALCULATE(

        SUM(

            Test[Value])))

VAR Maxvulue= MAXX(SelectedVersion,

    CALCULATE(

        SUM(

            Test[Value])))

VAR Difference = Maxvulue - Minvalue

RETURN

    Difference

Dataset:

Planning version	Planning date	Planning groupe	Value
1	01/01/2022	Citybike	10
1	01/01/2022	Mountain bike	20
1	01/01/2022	Race bike	50
1	01/01/2022	Cross bike	40
2	01/01/2022	Citybike	20
2	01/01/2022	Mountain bike	50
2	01/01/2022	Race bike	5
1	02/01/2022	Citybike	15
1	02/01/2022	Mountain bike	25
1	02/01/2022	Race bike	55
1	02/01/2022	Cross bike	45
2	02/01/2022	Citybike	20
2	02/01/2022	Mountain bike	50
2	02/01/2022	Race bike	5

In the result i am missing the delta for Cross bikes. 

Can any one help me? 

PBIX file: https://drive.google.com/file/d/1-S9nAhHpFyldQVtlOulMqPLxhhEq8tvP/view?usp=sharing

Regards,

Paul

[theunissenp]

Is there any one who can help me?

[v-easonf-msft · Accepted solution]

Hi， @theunissenp 

It is recommended to add a separate dimension table:

Planed version = DISTINCT(Test[Planning version])

In the matrix visual, you need replace field 'Planned Version' in fact table with field 'Planned Version' in new dimension table.

Best Regards,
Community Support Team _ Eason

[theunissenp]

Thanks for your reply. I added the table but the delta formula is not giving any value for the delta for Cross bikes...

Delta formula:

Delta =

VAR SelectedVersion=

VALUES('Planed version'[Planning version])

VAR Minvalue=

MINX(

    SelectedVersion,

    CALCULATE(

        SUM(

            Test[Value])))

VAR Maxvulue=

    MAXX(SelectedVersion,

    CALCULATE(

        SUM(

            Test[Value])))

VAR Difference =

    Maxvulue - Minvalue

RETURN

    Difference

Thanks for your respons.

Regards,

Paul

[tamerj1]

Hi @theunissenp 

Asking a question that might drive you to find solution. What is the expected results based on this sample?

[theunissenp]

Currently, the delta for cross bikes is missing. This is missing because this planning group is not planned in both versions. I want to show it anyway.