Forum Discussion
Filter 2 different measures using 2 different date slicers in the same matrix- Need help pls
Hi Team,
Need your support pls. I have a table with multiple rows and 2 measures in the values displayed as columns in the matrix.
I need to do following.
- Add 2 different slicers of total unique dates in the date table for the user selection in the report. Then,
- From the 1st slicer, user will select single or multiple dates which will be used to filter date table and calculate MEASURE 1 value.
- From the 2nd slicer, user will select a different set of dates which will be used to filter date table and calculate MEASURE 2 value.
Both of these measures will be displayed in the same matrix
I tried creating 2 seperate date tables and have 2 way join but I am not able to filter 2 measures in the same table with different dates. Whenever any slicer is used, it simply filters both the measures. If I avoid interaction, it gets stopped for both the slicers. There is no way to control it.
Then, I also tried to filter the date table in the MEASURES using SLICER VALUES from SELECTEDVALUE but again it is not filtering, no idea why..
Anonymous You need to remove the relationship of one of the date tables, let's say the 2nd one, and then use this for the 2nd measure:
Measure 2nd = CALCULATE ( [Measure Calculation], ALL ( YourTable ), TREATAS ( VALUES ( 'DateTable2'[Date] ), YourTable[Date] ) )
2 Replies
- parry2k
Super User
Anonymous You need to remove the relationship of one of the date tables, let's say the 2nd one, and then use this for the 2nd measure:
Measure 2nd = CALCULATE ( [Measure Calculation], ALL ( YourTable ), TREATAS ( VALUES ( 'DateTable2'[Date] ), YourTable[Date] ) )