Forum Discussion

Sriku's avatar
Sriku
Icon for Helper IV rankHelper IV
6 years ago

Bucket matrics and create RAG status

Hi Team,   Need to count the total metrics and the total bucket as Red >0 and Green =0: Country Metrics1 Metrics1 Metrics1 Metrics1 Total CA 0 0 0 0 0 OR 0 1 1 0 2 W...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Sriku ,

 

 Red >0 = CALCULATE(COUNTA(Table[County]), FILTER(Table , [metric1] = 1))

Green =0 = CALCULATE(COUNTA(Table[County]), FILTER(Table , [metric1] = 0))

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)