Forum Discussion
Gusd8
Helper I
Helper IPower BI Visual, two field filter but using OR
Greetings, thank you for looking I have a visual that displays activities and there is a field called "Error" which is a yes/no field and then a separate field called "Error Message" which is a text...
Use a Visual-level-filter with a measure
If you want the filter logic cleanly and reuse it, you can create a measure like this:
ShowRecordFlag = IF( [Error] = TRUE() || NOT(ISBLANK([Error Message])), //Try with && if || is not working 1, 0 )Then use Visual-level filter:
-
Drag ShowRecordFlag into the visual’s filters pane.
-
Set the filter to "is 1".
-
