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...
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] ) )
Many thanks. This is just exactly what I did and got my results few hours back. Anyways, really appreciate your feedback ...