countrows counting false and null

[Anonymous]

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

[mangaus1111 · Accepted solution]

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]

hi @mangaus1111 

this worked perfectly!!

thanks