Forum Discussion

junyetzotomayor's avatar
junyetzotomayor
Icon for Helper I rankHelper I
8 years ago

How to count active and inactive users based on login status?

Hi guys,   I have the below database table based on the login status of Users on our system. 2 - Inactive  1 - Active   I'm trying to count the users who logged-in (and didn't logged-in) ...
Custom Visuals
Dashboards
Data Modeling
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi junyetzotomayor,

 

You can create measures below: 

 

Active = CALCULATE(DISTINCTCOUNT(Table1[UserID]),FILTER(ALLSELECTED('Table1'),'Table1'[Login Status]=1&&Table1[Day]=MAX('Table1'[Day])))

 

Inactive = CALCULATE(DISTINCTCOUNT(Table1[UserID]),FILTER(ALLSELECTED(Table1),Table1[Day]=MAX('Table1'[Day])))-CALCULATE(DISTINCTCOUNT(Table1[UserID]),FILTER(ALLSELECTED('Table1'),'Table1'[Login Status]=1&& 'Table1'[Day]=MAX('Table1'[Day])))

 

 

 

 

Best Regards,
Qiuyun Yu 

junyetzotomayor's avatar
junyetzotomayor
Icon for Helper I rankHelper I
8 years ago

Hi v-qiuyu-msft,

 

Thanks for the feedback. Just a few more queries below.

 

1. I added 'Active' and 'Inactive' cards and filters in the PBI. Why is it counting only 1 inactive user wherein all users have at least logged in recordin my specifed timeframe (all dates selected).

2. Why the counts in the cards are showing different from the chart.

 

 

 

 

 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi junyetzotomayor,

     

    This is due to the chart has placed Day column in chart X axis, which will filter measures. While you place my measures in card visual, it process whole table and display values based on final day, in your scenario, it's 13. This is expected. 

     

    Best Regards,
    Qiuyun Yu