How to do OR between two columns?

[mroomi]

Hi All,

So currently I can do an OR in filters on one column e.g, If Date is less then "1" OR Greater than "10". But I want to do an OR between two columns.

If [code1] is 290 OR [code2]  is 310 then do this.

Thanks.

[samdthompson]

there will be a smarter way but make a third column which holds your =OR() function then reference that for your measure. If something might be used as a filter or used in a relative context keep it in a column rather than a measure.

//if this is a solution please mark as such

[samdthompson · Accepted solution]

there will be a smarter way but make a third column which holds your =OR() function then reference that for your measure. If something might be used as a filter or used in a relative context keep it in a column rather than a measure.

//if this is a solution please mark as such

[Anonymous]

Taking a guess at what you are looking for... likely this works...

  = CALCULATE ( [MyMeasure], FILTER (MyTable, MyTable[Code1] = 290 || MyTable[Code] = 310)

[mroomi]

Thanks Scottsen,

But I wanted to do this at report level, where user can achive this using the report level filters.

Or else I have to create multiple measures and the biggest problem is to filter doesnt work on the visual when you use the measures.

[Eric_Zhang]

@mroomi

So far the report level filter can't acheive your requirement. You can submit your feedback on Power BI Ideas.

You may follow @Anonymous's advice to use lookup tables. For example, one table for code1 range and another for code2 range, use two slicers and create two measures to get the selected range number. Then apply those two measures to your DAX fomulas.

[Anonymous]

That... is going to be challenging.

Hopefully somebody else chimes in with an idea.  The only thing I can think of is having lookup tables that are NOT related to your fact table (otherwise the default AND behavior will take over), then write some tricky DAX measures to filter the fact rows based on selections in the "disconnect tables" based on an OR pattern.