Forum Discussion
Subtract the data from two dynamic tables
Hello
"Hello everyone,
I am new to Power BI and I would like to find a solution to subtract data from two tables based on the filter choices at the top and bottom (see below). The data source is the same.
thanks a lot !!!
Hi anasofia92500 ，
Based on the information you provided, it appears that your slicers are created from a field parameter table composed of measures.
This field parameter is also used in the matrix.
If so, what you need is the difference between the two slicer options (two measures).
You can create a new measure equal to two slicer options (two measures) subtracted to get the target result.Below are the test results.
Please see the attached pbix for reference.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi,
Share the download link of the PBI file.
could you pls provide some sample data and expected output?
Hi anasofia92500 ，
Based on the information you provided, it appears that your slicers are created from a field parameter table composed of measures.
This field parameter is also used in the matrix.
If so, what you need is the difference between the two slicer options (two measures).
You can create a new measure equal to two slicer options (two measures) subtracted to get the target result.Below are the test results.
Please see the attached pbix for reference.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
