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
Community Support



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