Forum Discussion
Solved
Filter DIM based on Slicer Values
Hey, I have 3 Tables in my model, which are DimUsers, DimDate and FactSales. A slicer is showing month names from DimDate. I want to find out users that are created in selected month from slicer...
Pinoo39 , Create an inactive relation between date and created_at and try useuserelation. You might have to use crossfilter(none) for fact
Sign Up = CALCULATE([User Counts], userelation(DimDate[Date], 'DimUsers'[created_at]))
refer: https://www.youtube.com/watch?v=e6Y-l_JtCq4
Another way is
Sign Up = CALCULATE([User Counts],filter(DimUsers , DimUsers[created_at] in values(DimDate[Date])))
or
Sign Up = CALCULATE([User Counts],filter(DimUsers , DimUsers[created_at] in allselected(DimDate[Date])))
