Forum Discussion

LostnFound's avatar
LostnFound
New Member
4 years ago
Solved

Count and Filtering TRUE and FALSE

Hello, I'm new to Power BI and I have a single table that shows products with their status in a number of columns as either TRUE or FALSE. I'm looking to count the number of products that are under I...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    hi LostnFound 

     

    Try this measure

    #Inpection =
    CALCULATE (
    COUNTROWS ( 'Stock_Daybook' ),
    AND (
    Stock_Daybook[UnderRepair]
    = FALSE (),
    Stock_Daybook[UnderInspection]
    = TRUE ()
    )
    )
     
    If this post helps, Accept it as a solution.
Anonymous's avatar
Anonymous
Not applicable
4 years ago

hi LostnFound 

 

Try this measure

#Inpection =
CALCULATE (
COUNTROWS ( 'Stock_Daybook' ),
AND (
Stock_Daybook[UnderRepair]
= FALSE (),
Stock_Daybook[UnderInspection]
= TRUE ()
)
)
 
If this post helps, Accept it as a solution.