Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.
      

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.