Forum Discussion
How to Fix Measure Not Affected by Slicer
I have two sets of slicers: the first set (consisting of three slicers) applies to all pages in the report while the second one (consisting of one slicer, let's call this the "rogue slicer") only applies to this specific page. All these slicers are from the same table (let's call this table "Table 1").
I have this measure in a different table (let's call this table "Table 2", this has a relationship with Table 1) which needs to be filtered based on all four slicers but currently it is only getting filtered by the first set of slicers when any of those three slicers have a non-default value. When at the default value of All for all three slicers, the rogue slicer works.
I have tried creating a separate table for the rogue slicer value (let's call this table "Table 3") but to no avail. I have tried the following measures as well:
1. MaturityAvg = AVERAGE('Table 2'[maturityInt])
2. MaturityAvg = CALCULATE(AVERAGE('Table 2'[maturityInt]), TREATAS(VALUES('Table 3'[QUESTION_AREA_TITLE]), 'Table 1'[QUESTION_AREA_TITLE))
Would anyone know what I'm missing here?
2 Replies
- Analystmate
Helper II
This might cause cross-filtering when the direction of detection is set to "Single".
Set cross-filtering directions "Both" then try to filter using a slicer filter should impact
- agcruzFrequent Visitor
Hi! I already have it set to Both. Would you know where else could the issue be?