Creating a DAX measure that filters on a Boolean field always evaluates to BLANK() when:
If either of the above is not true, then the measure evaluates correctly. Here are steps to re-create:
create table boolean_test(id int identity,is_weekend bit)
insert into boolean_test values(1)insert into boolean_test values(1)insert into boolean_test values(0)
The issue is reported internally : CRI 196344803.
We’ve identified the issue. As the fix involves lots of evaluation, coding and testing, there is no ETA at this time.