Use Filter based on Columns

[Anonymous]

Hello, 
I have a report with a dataset containing a column with values:
True

False

Other

I wish to create a filter with values:

True = True + Other

False = False + Other

any suggestions would be highly appreciated,

Thanks!

[themistoklis]

@Anonymous

If you are planning to use the filter on a measure you ca use the following:

Measure = CALCULATE(SUM('Table'[Value]), 'Table'[ColumnName]="TRUE" || 'Table'[ColumnName]="Other")

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846

[Greg_Deckler]

You should be able to do that in the Filters area of your visual (or report or page). If you want a DAX filter, that would be:

FILTER('Table',[Column]="True" || [Column]="Other")