Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I am really having trouble with Power BI and multiple slicer logic. I will simplify my data a bit to hopefully make it easier to convey my lack of understanding.
I have a table OUTPUT that contains the following columns {verified_first, verified_last, verified_phone, verfied_email} where my intention is to allow a user to select values using a slicer to see what the rate would be for different combinations. Essentially, a way to model different scenarios.
For example:
1: verified_last AND verified_phone = 50 records
2: verfied_first AND verified_last AND verified_phone = 40 records
3: verfied_first AND verified_last OR verified_phone = 55 records
I have found a way to get the results I am looking for in DAX by using some calculations and new columns, but this of course requires syntax to change in order to allow for specific conditions to be tested. An example:
The values in a given slider uses OR logic while sliders in conjunction with each other use AND.
Correct. This is a design decision, and it is the expected behavior for the UI. If you don't like that, please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com