Calculate difference based on two slicers

[BInewbie]

I have two charts that show the time take to move in each step of a process.

Both charts have there own respective slicer associated with it to select a month.
How would I create a measure to look up the values based on the month selected in order to calculate the difference

Thank you

[v-frfei-msft · Accepted solution]

Hi @BInewbie,

Please share sample data of your tables so that we can provide you appropriate DAX.

Here is an example for you.

1. Enter the data accordingly.
2. Create the three measures as below:

sumtable1 = CALCULATE(SUM(Table1[take]),ALLSELECTED(Table1[Month1]))

sumTable2 = CALCULATE(SUM(Table2[Take]),ALLSELECTED(Table2[Month2]))

look up the values = [sumtable1]-[sumTable2]

Then we can get the result as the picture below.

For more information, please check the pbix as attached.

https://www.dropbox.com/s/vir7f6ilq5bzhog/Calculate%20difference%20based%20on%20two%20slicers.pbix?d...

Regards,

Frank

[v-frfei-msft]

Hi @BInewbie,

Does this make sense? If so, kindly mark the answer as solution please. Thanks!

Regards,
Frank