Forum Discussion
CatieBeth
4 years agoRegular Visitor
Convert True/False to 0 & 1 off Calculated Field
I have a Calculated field showing where I need to see how many installs are pending from 0-14 days the calcualtion is:0-14 Days = 'Drop Installs'[Days Past Due]<=14 (I got the Days Past Due from ano...
- 4 years ago
Hi CatieBeth ,
I created some mockup data:
And I used this measure:
BooleanMeasure = CALCULATE ( COUNTROWS ( TableBoolean ), TableBoolean[Boolean] = true )
And I got the correct result:
Maybe you wanna try the same syntax as my statement above to start with?
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
CatieBeth
4 years agoRegular Visitor
That worked!! Thank you so much!!!