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
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
It Workeed. Thank you so much Anonymous
