Forum Discussion
Helper IIIDAX Not Responding to Slicer Selection
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?
ElvirBotic You need to modify your cross-filter direction of your Training to Users relationship to Both.
8 Replies
- Greg_Deckler
Community Champion
ElvirBotic You need to modify your cross-filter direction of your Training to Users relationship to Both.
ElvirBoticI 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.
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))
