DAX Involving TRUE/FALSE Column

[nirvana_moksh]

Hello Community,

How do you deal with writing a DAX Statement that invloves a column that is of data type TRUE/FALSE without converting it to text and making it to work?

Thank You

[idkwhatimdoing]

@NKL make sure you're adding a column and not a measure

[idkwhatimdoing]

besides, you don't have to create a column or measure to count the #'s of true/false fields. Just use counta in a measure:

CALCULATE(

    COUNTA('Table'[Column]),

    'Table'[Column] IN { TRUE() }

[Ashish_Mathur]

Hi,

Your question is not clear.  Show a dataset and the expected result.

[nirvana_moksh]

So I was using a calculated IF statement and it was using a column which was 'TRUE/FALSE' data type and for some reason the DAX did not recognize that and I had to convert that column to Text for it to work

[v-yulgu-msft · Accepted solution]

Hi @nirvana_moksh,

Maybe you need something similar to below. Here [Column1] comtains 'TRUE/FALSE' data type values.

New column = 
IF ( Table[Column1] = TRUE (), 1, 0 )

Regards,

Yuliana Gu

[NKL]

This actually is not allowed in my case because a single value for the TRUE/FALSE data type field "Active Schedule" cannot be determined

Can you figure out why it is not working?

[Smamwise]

You might be trying to create a measure. Try a calculated column instead.