Forum Discussion
anasofia92500
1 year agoNew Member
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 th...
- Anonymous1 year ago
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.
anasofia92500
1 year agoNew Member
- Ashish_Mathur1 year ago
Super User
Hi,
Share the download link of the PBI file.