Forum Discussion
Community ChampionCalculating Benchmark - ALLEXCEPT not quite working
Hi rsbin
Create a date table which has no relationship with fact table,
create a measure
Measure 2 = CALCULATE( [idcount]/[visit],FILTER(ALL('Table 3'),'Table 3'[date]>=MIN('date'[Date])&&'Table 3'[date]<=MAX('date'[Date])))slicer "facility" won't change the value of [Measure 2], the date slicer would change the [Measure 2].
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi rsbin
Create a date table which has no relationship with fact table,
create a measure
Measure 2 = CALCULATE( [idcount]/[visit],FILTER(ALL('Table 3'),'Table 3'[date]>=MIN('date'[Date])&&'Table 3'[date]<=MAX('date'[Date])))
slicer "facility" won't change the value of [Measure 2], the date slicer would change the [Measure 2].
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionHi Maggie,
I am trying better to understand your solution. My entire data model is premised on a Fact Table and a related Calendar Table. I currently use this Calendar Table as my Slicer throughout my multi-page report. I have dozens of Measures that are based on the date range selected by the User.
Introducing another unrelated Date Table as you suggested, and using that as a Slicer, would affect all the other visuals I have on my report page - would it not?
Kind Regards,