Forum Discussion

Pinoo39's avatar
Pinoo39
Frequent Visitor
5 years ago
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...
  • amitchandak's avatar
    amitchandak
    5 years ago

    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])))

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Pinoo39 

Try this

 

Sign Up =
CALCULATE (
    DISTINCTCOUNT ( 'DimUsers'[User_ID] ),
    'DimUsers'[created_at_DimDateKey] IN DISTINCT( DimDate[Date] )
)

 

 

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers