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

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , in case you are using slicer to filter values and see % of that

divide(count(Table[user]), calculate(count(Table[user]), all(Table)))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I don't think i understand the suggestion? My denomenator should be the count of all users in the "registered_user" in the table and my numerator should be distinct count of users in the "1year_user_activity" table that are also in the "registered_user" table. This numerator should be changing based on the slicer on activity type.