Forum Discussion
DAX Involving TRUE/FALSE Column
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
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
7 Replies
Hi,
Your question is not clear. Show a dataset and the expected result.
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
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 make sure you're adding a column and not a measure
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() }
