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
Try:
not logged in =
VAR users = VALUES(DIM total users[user])
VAR logged = VALUES(Fact_Login event[user])
RETURN
COUNTROWS(EXCEPT(users,logged))
Create the visual/table/chart with the DIM total user[user] field, and in the filters for the visual in the filter pane add this measure [not logged in ] and establish the filter value as 1