Forum Discussion
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.
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]) - _sumtable22. 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
2 Replies
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]) - _sumtable22. 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