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 yashwant101 ,
The question is that you are using the SELECTEDVALUE this is dependent on a single select value and that create your limitation of the formula. Taking into account that you have a combination of two tables you need to configure a different setup that does the combination between this value and then return a value for you to filter upon.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Hi MFelix ,
Thanks for your response. Uploaded the file here
In this file, as you can see we have a grid and a custom time slicer. I have added one column in the end a sPatient wise Total Copay. We need the filter in right (of the copay bucket) to filter the grid, and the copay bucket slicer is multiselect depending on the time slicer.
Your help is highly appreciated.
Regards,
Yashwant