Forum Discussion
Need help in DAX
Hi experts, I have a problems that need your help. I got 3 table: 1. Fact Table: Login Event 2. Dim Table: Total users 3. Dim Table: Date The relationship will look like below picture ...
Anonymous
You can find not login users with NOT in Values() function:
Not login users = CALCULATE(MAX('DIM total users'[user]), FILTER('DIM total users', NOT('DIM total users'[user]) in VALUES( Fact_Login event[user])))
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , Make the join between Date and use as inactive and User dim Login Fact as active.
When you need some data from use dime with date cross filter with fact login and use relation with.
refer