Forum Discussion
Count Rows up to date of Row
If you're using a calendar table with a year column (as an example), you need to create relations between your fact table and calendar table on the date column.
If you want your measure to be filtered by this slicer, then you need to change it a bit: use ALLSELECTED instead of ALL.
Hello ERD
Thnaks for this measure, I think it works for me!!! Before acceting this as solution I have one more question.
I have 84 lines in this table and growing. I was thinking to use slicer for 2020/2021. Due to my limited understading of this new language I cannot figure out how to make it date slicer sensitive - for now it soesnt react ot slicer?!
Any additional ideas?
Thnaks a lot
Aleks
Community ChampionIf you're using a calendar table with a year column (as an example), you need to create relations between your fact table and calendar table on the date column.
If you want your measure to be filtered by this slicer, then you need to change it a bit: use ALLSELECTED instead of ALL.