Forum Discussion
jayasurya_prud
4 years agoAdvocate III
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...
- 4 years ago
jayasurya_prud , try like
# color and availability = (calculate(COUNTROWS(filter(table1,tavle1[red] = "no" && isblank( table1[available] ) ))))
amitchandak
4 years agoSuper User
jayasurya_prud , try like
# color and availability = (calculate(COUNTROWS(filter(table1,tavle1[red] = "no" && isblank( table1[available] ) ))))