Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
8 years ago
Solved

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
Need Help
Show and Tell
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

     

idkwhatimdoing's avatar
idkwhatimdoing
Icon for Advocate I rankAdvocate I
3 years ago

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

idkwhatimdoing's avatar
idkwhatimdoing
Icon for Advocate I rankAdvocate I
2 years ago

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() }