Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
LoayN
New Member

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
1 ACCEPTED SOLUTION
mangaus1111
Solution Sage
Solution Sage

Hi @LoayN ,

 

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.

View solution in original post

2 REPLIES 2
mangaus1111
Solution Sage
Solution Sage

Hi @LoayN ,

 

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.

hi @mangaus1111 

 

this worked perfectly!!

thanks

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors