DAX Not Responding to Slicer Selection

[ElvirBotic]

Hello, I have a star schema and I am trying to create a measure that will provide me the total number of users broken down by account. There are a total of 20k users and when visualized in a table by account the total number of users is the same for all accounts. Do I need to use crossfilter? selectedvalue? 

[v-yangliu-msft]

Hi  @ElvirBotic ,

What is your Dax like, can you share it?

You can create a calculated table, which contains the columns for the slicer to use.

For example:

Slice Table =
SUMMARIZE('Table','Table'[date])

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[ElvirBotic]

I used the following DAX.

Total Users = CALCULATE(

DISTINCTCOUNT(Users[User Id]),

CROSSFILTER(Training[User Id], Users[User Id], Both)

)

[Greg_Deckler · Accepted solution]

@ElvirBotic You need to modify your cross-filter direction of your Training to Users relationship to Both.

[ElvirBotic]

I see. Thank you. Is this a scenario where using bi-directional filtering is okay? I was told to stay away from it like the plague. 

[Greg_Deckler]

@ElvirBotic Whoever told you that was smoking crack.

[ElvirBotic]

Is there a way to when using a slicer not have the "Total Users" measure not be impacted by different slicer inputs? Right now everytime I select a month or account it will also filter the table with the measure and I want it to always show a constant value. 

[Greg_Deckler]

@ElvirBotic Sure, use ALL or ALLEXCEPT or REMOVEFILTERS for instance in your measure to obliterate the existing filter context.

[ElvirBotic]

I think I am doing something wrong.  The below DAX is still being affected by the month slicer in my model. 😞

Total Users = CALCULATE(

DISTINCTCOUNT(Users[User Id]),

CROSSFILTER(Training[User Id], Users[User Id], Both),

REMOVEFILTERS( 'Date'[Month] )

)