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 Mot...
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.

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    hi mangaus1111 

     

    this worked perfectly!!

    thanks