Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

calculated column with VALUES function on another table being filtered by slicer

I have 2 tables. first is "registered_users" which is all of my currently registered users name user_id alex 1 sarah 2 joe 3 bill 4 second is "1year_user_activity" which is a...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    5 years ago

    hi  Anonymous 

    Just adjust the formula as below:

    registered_user_activity_rate = 
DIVIDE (
    CALCULATE(DISTINCTCOUNT ( '1year_user_activity'[user_id] ),FILTER('1year_user_activity','1year_user_activity'[user_id] in VALUES(registered_users[user_id]))),
    COUNT ( 'registered_users'[user_id] )
)

    Result:

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
5 years ago

hi  Anonymous 

Just adjust the formula as below:

registered_user_activity_rate = 
DIVIDE (
    CALCULATE(DISTINCTCOUNT ( '1year_user_activity'[user_id] ),FILTER('1year_user_activity','1year_user_activity'[user_id] in VALUES(registered_users[user_id]))),
    COUNT ( 'registered_users'[user_id] )
)

Result:

 

Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you v-lili6-msft , this solved the problem perfectly. I didn't understand how to use the CALCULATE function correctly