Forum Discussion
Solved
Single Measure for multiple filters
Hi, There are two tables (or more) in which I have 'Users' column for each dimension, and I am looking for a single measure which would give me the count of users, when I select the filters. ...
You can do something like this:
MEASURE =
VAR1 = Sum(Table1[Users])
VAR2 = Sum(Table2[Users])
RETURN
SWITCH(
TRUE;
ISFILTERED(Table1); VAR1;
ISFILTERED(Table2); VAR2
)
This should work if there aren't other complications in the data
Create a common user table
User =distinct(union(all(table1[user]),all(table2[user])))
Join it both the tables. Or you can count distinct user from it