OR logic in multiple filters

Question

Dear experts,&nbsp;The default logic for multiple filters is 'AND'. Anyone knows how to apply filters with 'OR' logic for the table? My aim is to filter Potential Risk = "Un-defined" or RA Total = 0&nbsp;&nbsp;&nbsp;

samarth_18 · Accepted Answer

Hi&nbsp;JAWL&nbsp;,
&nbsp;
To get specific answer please share the sample data.
However, you could try to create a measure as below and use it as visual level filter:-
_filter =
IF (
    OR (
        MAX ( table[Potential Risk] ) = "Un-defined",
        SUM ( Table1[RA Total] ) = 0
    ),
    1,
    0
)

&nbsp;

Forum Discussion

OR logic in multiple filters

2 Replies

Related content

Logic problem?

FX Conversion Logic

Multiple Years Filter

DAX FILTER with multiple criteria

Slicer by logic conditions