Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

countrows counting false and null

hi i am new to power BI i have the following measure

 

Cal Motor Fails = COUNTROWS(FILTER(PA1302, PA1302[Calibrate Motor]=FALSE()))
 
i want to count the number of "falses" in the "Calibrate Motor" column. the problem is that the above measure counts FALSEs and null together.
 
i want to separate them.
 
thanks in advance
Loay
Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    Hi Anonymous ,

     

    use  'Table'[Calibrate Motor] == FALSE(), instead of 'Table'[Calibrate Motor] = FALSE()

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    Hi Anonymous ,

     

    use  'Table'[Calibrate Motor] == FALSE(), instead of 'Table'[Calibrate Motor] = FALSE()

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.