How to substract two measures?

Question

Hi,&nbsp;I am trying to display a value in a card that subtracts two measures that are affected by slicers.&nbsp;&nbsp;So basically I have a column of TotalSales and a slicer that has Dates in it.&nbsp;&nbsp;Measure1 = Sum[TotalSales]*This measure will be displayed in a card and it have a date slicer that will only interact with this measure.&nbsp;Measure 2 = SUM[TotalSales]*This measure will be displayed in a second card visual and have a separate dale slicer that will only interact with this measure. I am basically trying to show the sum value of TotalSales at different time periods.&nbsp;Measure 3 = Measure 1 - Measure 2*This will be displayed in a third card visual and the value should change according to the slicers in Measure 1 and Measure 2

idrissshatila · Answer

Hello&nbsp;immadahmad,
&nbsp;
it won't work like this, you need to specify the filtering in the measure.

immadahmad · Answer

Thanks for the prompt response. Can you please help with rewriting Measure 3 in my problem?Do I use FILTER? But with FILTER I will have to specify the exact dates I want to filter?

chakravarthy · Answer

immadahmad&nbsp;,&nbsp;Seems like you need one independent slicerYou need to have two slicer&nbsp;refer- https://youtu.be/WSeZr_-MiTg

Forum Discussion

How to substract two measures?

3 Replies

Related content

Substract column - measure

Substraction in measure

Cumulative substraction over categories

Substracting data for proper visualization

Substraction