cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot use binary measure as visual / page / report filter

When creating a measure as binary

 

Measure = SELECTEDVALUE(Table1[Field1])=SELECTEDVALUE(Table2[Field2])

 

the measure cannot be filtered for True/False.

 

When changing the measure to numeric

 

Measure = IF(SELECTEDVALUE(Table1[Field1])=SELECTEDVALUE(Table2[Field2]),1,0)

 

filtering becomes possible.

 

Please enable filtering for True/False

Status: New
Comments
Community Support

@lbendlin 

 

There is already an idea, you may leave a comment and vote it up.