Subtract two tables values based on two different slicer values

[Anonymous]

We've a requirement to display the difference of two measure fields. Shared example for your reference :

Your cooperation in this regard will be highly appreaciated. 

[Anonymous]

Thanks for providing quick solution. Implemented this logic and it worked as expected.

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _selecttable2=SELECTEDVALUE('Table2'[Month])
var _sumtable2=SUMX(
    FILTER(ALL('Table2'),'Table2'[Month]=_selecttable2&&'Table2'[Client]=MAX('Table1'[Client ID])),[Sales])
return
SUM('Table1'[Sales]) - _sumtable2

2. Result:

Best Regards,

Liu Yang

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