Forum Discussion
How to use two different fields in one filter
DAX has an OR function. Use that to create boolean answers to whatever question you want to answer.
So for your example, "I want to show anyone who owns a Chevy or Ford car, and/or a Harley bike, and/or takes the bus."
you can create True/False statements as filters combining AND and OR statements. So something along these lines:
(A = "Chevy" OR "Ford") OR (B = "Harley") OR (C = "Bus")
As long as one of these things is true, the whole statement will return TRUE. If you want to see people who have a Chevy or Ford and drive the bus, just change an OR to an AND:
(A = "Chevy" OR "Ford") AND (C = "Bus")
DAX has an OR function. Use that to create boolean answers to whatever question you want to answer.
So for your example, "I want to show anyone who owns a Chevy or Ford car, and/or a Harley bike, and/or takes the bus."
you can create True/False statements as filters combining AND and OR statements. So something along these lines:
(A = "Chevy" OR "Ford") OR (B = "Harley") OR (C = "Bus")
As long as one of these things is true, the whole statement will return TRUE. If you want to see people who have a Chevy or Ford and drive the bus, just change an OR to an AND:
(A = "Chevy" OR "Ford") AND (C = "Bus")