Forum Discussion
Multiselect with Disconnect Table
Hi yashwant101
Please try the following measure:Measure = IF(ISFILTERED('Patient Copay Amount'[Patient Copay]), SWITCH( TRUE(), "0-50" IN VALUES('Patient Copay Amount'[Patient Copay]) && [Total Copay]<=30, 1, "50-100"IN VALUES('Patient Copay Amount'[Patient Copay])&& [Total Copay]>30 && [Total Copay]<=100, 1, "100-150"IN VALUES('Patient Copay Amount'[Patient Copay]) && [Total Copay]>100 && [Total Copay]<=160, 1, "150-200"IN VALUES('Patient Copay Amount'[Patient Copay]) && [Total Copay]>160, 1, 0 ),1 )
Result:Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Thanks for your response. If I use this formula when the first condition becomes correct, the rest are not executed. But since it is multiselect I want all teh statements to be executed. I have placed the file here
I have explained the requirement in the other response. Please have a look and let me know a way to achieve this.
Regards,
Yashwant
Hi yashwant101
Please try the following measure:
Measure = IF(ISFILTERED('Patient Copay Amount'[Patient Copay]),
SWITCH(
TRUE(),
"0-50" IN VALUES('Patient Copay Amount'[Patient Copay]) && [Total Copay]<=30, 1,
"50-100"IN VALUES('Patient Copay Amount'[Patient Copay])&& [Total Copay]>30 && [Total Copay]<=100, 1,
"100-150"IN VALUES('Patient Copay Amount'[Patient Copay]) && [Total Copay]>100 && [Total Copay]<=160, 1,
"150-200"IN VALUES('Patient Copay Amount'[Patient Copay]) && [Total Copay]>160, 1,
0
),1
)
Result:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.