Forum Discussion
mbailey
Helper II
Helper IICOUNTAX not working properly
Hi, I have a table with example data like this: In this example, it is filtered to one Unit/Partner Name, but the table contains many combinations of Units/Partners. You can see in this exam...
mbailey Try:
High Priority Count = COUNTROWS(FILTER(DMTA_Service_Report, DMTA_Service_Report[priority] = "High"))COUNTAX returns the number of values that are non-blank and DMTA_Service_Report[priority] = "High" is either true or false for each row, not blank.
I think you want something more like
High Priority Count = COUNTROWS ( FILTER ( DMTA_Service_Report, DMTA_Service_Report[priority] = "High" ) )
Greg_Deckler
Community Champion
Community Championmbailey Try:
High Priority Count = COUNTROWS(FILTER(DMTA_Service_Report, DMTA_Service_Report[priority] = "High"))