topic Measure to calculate delta between selected planning version in DAX Commands and Tips

Measure to calculate delta between selected planning version

Anonymous — Tue, 31 May 2022 12:02:52 GMT

Hi all,

I'm trying to create a measure that will calculate the delta between selected planning version. My simplified datamodel is as follows:

Version	value
Planning_1	10
Planning_2	20
Planning_3	25
Planning_4	8

Result should be usable in a matrix visual:

column1: planning version A

column2: planning version b

column 3: delta

Thanks you very much for your respons!

Regards,

Paul Theunissen

Re: Measure to calculate delta between selected planning version

Whitewater100 — Tue, 31 May 2022 12:42:07 GMT

Hi Paul:

Can you give sme examples of expected results? I'm not sure what you want to compare your selected value to? Thanks..

Re: Measure to calculate delta between selected planning version

Anonymous — Tue, 31 May 2022 12:45:42 GMT

In the matrix the expected result shoud be:

when planing_1 and planning_2 are selected:

Re: Measure to calculate delta between selected planning version

Whitewater100 — Tue, 31 May 2022 14:00:13 GMT

Hi:

I looked up a potential solution for you. Please check out this previous answer and I hope this helps!

https://community.powerbi.com/t5/Desktop/Compare-Data-based-on-2-selected-values-in-1-column/td-p/1502679

Re: Measure to calculate delta between selected planning version

Anonymous — Wed, 01 Jun 2022 08:22:15 GMT

Thanks for your help. Unfortunately this solution doesn't work for me... I get the message that I want to compare text with numbers

Re: Measure to calculate delta between selected planning version

v-xiaotang — Fri, 03 Jun 2022 09:11:23 GMT

Hi Anonymous

One idea,

create the measure

Measure = var _count= COUNTX(ALLSELECTED('Table'[Version]),[Version]) var _max= IF(_count=2,MAXX(ALLSELECTED('Table'),'Table'[value])) var _min= IF(_count=2,MINX(ALLSELECTED('Table'),'Table'[value])) return IF(HASONEVALUE('Table'[Version]),SUM('Table'[value]),_max-_min)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Re: Measure to calculate delta between selected planning version

Anonymous — Thu, 16 Jun 2022 08:35:08 GMT

Thanks! This helps a lot. One more question. Is it also possible to create a measure that calculates a difference for multiple dimension: Version, cost center and year, quarter and month?

example:

Re: Measure to calculate delta between selected planning version

Anonymous — Thu, 16 Jun 2022 08:36:09 GMT