Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Subtract two tables values based on two different slicer values

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. 
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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