Forum Discussion

NithinBN's avatar
NithinBN
Icon for Helper II rankHelper II
6 years ago
Solved

Multiple Filter (Countrows) which includes Text and boolean

Hello All, I want to count rows based on filters which includes both text and boolean values.   Here  is my query which includes both text and boolean. Overall_Green = CALCULATE(COUNTROWS(Table1)...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    NithinBN , if active is boolean first two should work. else try thrid one

     


    Overall_Green = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[colour]="Green" && Table1[Active]))

    Overall_Green = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[colour]="Green" && Table1[Active]=true()))

     

    Overall_Green = CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[colour]="Green" && Table1[Active]="True"))

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

NithinBN Try:

Overall_Green = 
  COUNTROWS(
    FILTER(Table1,Table1[colour]="Green" && Table1[Active]="True")
  )