Forum Discussion

jayasurya_prud's avatar
jayasurya_prud
Advocate III
4 years ago
Solved

Count, Filter for multiple columns

I am working on a measure, I am not getting my count value. Instead I am getting blank.    The requirement is to get the count of combined result of -  red is no and available is blank   # color...
  • amitchandak's avatar
    4 years ago

    jayasurya_prud , try like

     

    # color and availability = (calculate(COUNTROWS(filter(table1,tavle1[red] = "no" && isblank( table1[available] ) ))))