Forum Discussion

deb_power123's avatar
deb_power123
Icon for Helper V rankHelper V
5 years ago

Get the column difference after filter selection

Hello Everyone   I need the DAX measure expression for the below scenario.   For my table Sales, I have 4 columns-Quateryear, SalesAmount-A, SalesAmount-B,Place.   Both the  column values of Sa...
Need Help DAX
Need Help DAX measure
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Where is the Tokyo value for Q12017?

 

You probably need to duplicate your data table, and use one copy for the A filter and the other copy for the B filter. Then use a measure to calculate the difference between the selected items. You will need to lower your expectations on the output format, it is not possible to implement it exactly as in your example.