Forum Discussion
Need help with a Measure - also have 2 slicers
I am using the following measure, but it's not giving me the results I need: All of my data is in a single table/sheet. I am using 2 slicers that filter the same data. 'Sheet1'[Compariso...
Hi cmazur71 ,
I'm afraid this can't be achieved solely through DAX, as CUT_COMP1 and CUT_COMP2 are each influenced by the slicers on Comparison1 and Comparison2, respectively. This causes a conflict between the slicers. However, to calculate CUT_COMP2 - CUT_COMP1, both slicers need to be active at the same time, resulting in a blank output for the calculation. I would recommend adjusting the data model by splitting the table into two or more tables, allowing separate calculations and avoiding slicer conflicts.
Best Regards,
Bof