Forum Discussion
2 fields using 1 filter
Hello Community,
I need your help with this problem below.
I have 2 checkbox fields (Field A & Field B).
What I need is to create a filter (with values Yes & No).
Behavior:
1) When Yes is selected then Field A & Field B should be selected as true (checked)
2) When NO is selected then Field A & Field B should be selected as false (unchecked)
Is this possible? What would be the best appoach to handle this? Thanks
danextian , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:
Hi fregie ,
I created some data:
Here are the steps you can follow：
1. Enter data – create slicer table.
2. Create measure.
Flag = var _select=SELECTEDVALUE('Slicer_Table'[Value]) return SWITCH( TRUE(), _select="Yes" && MAX('Table'[Group]) in {"Filed A","Filed B"},1, _select="No" && NOT(MAX('Table'[Group])) in {"Filed A","Filed B"},1,0)3. Place [Flag]in Filters, set is=1, apply filter.
4. Result:
If my explanations don't meet your expected results or don't understand your question, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
danextian , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:
Hi fregie ,
I created some data:
Here are the steps you can follow：
1. Enter data – create slicer table.
2. Create measure.
Flag = var _select=SELECTEDVALUE('Slicer_Table'[Value]) return SWITCH( TRUE(), _select="Yes" && MAX('Table'[Group]) in {"Filed A","Filed B"},1, _select="No" && NOT(MAX('Table'[Group])) in {"Filed A","Filed B"},1,0)3. Place [Flag]in Filters, set is=1, apply filter.
4. Result:
If my explanations don't meet your expected results or don't understand your question, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
