topic Re: Filter DIM based on Slicer Values in DAX Commands and Tips

Filter DIM based on Slicer Values

Pinoo39 — Tue, 01 Dec 2020 19:52:32 GMT

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. Normally if cross direction relationship is active the count of user_ids will show users in FactSales in the selected month but I need all users even if they have not bought any items.

I need Users that have been signed up in the selected month from slicer. the DimUsers contains a column (created_at) showing the users's creation date.

Here is the DAX I wrote but its not working

Any Ideas ?

Re: Filter DIM based on Slicer Values

CNENFRNL — Wed, 02 Dec 2020 01:47:35 GMT

Pinoo39 , you may try this

Re: Filter DIM based on Slicer Values

amitchandak — Wed, 02 Dec 2020 02:37:09 GMT

Pinoo39 , Create an inactive relation between date and created_at and try useuserelation. You might have to use crossfilter(none) for fact

refer: https://www.youtube.com/watch?v=e6Y-l_JtCq4

Another way is

Re: Filter DIM based on Slicer Values

AlB — Wed, 02 Dec 2020 09:55:25 GMT

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