Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
v-chuncz-msft
Community Support

@lbendlin 

 

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