Bucket matrics and create RAG status

[Sriku]

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
WE	0	0	0	0	0
IN	1	0	0		1
LI	0	0	0		0
TE	0	0	0	0	0
SO	0	1	1	0	2
LI	0	0	0		0
DE	0	0	0	0	0

[amitchandak]

@Sriku , how come are Metrics has the same name Metrics1

You can create a new measure

Total = sumx(Table,[Metrics1] +[Metrics2]+[Metrics3]+[Metrics4])

[harshnathani]

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)

[harshnathani]

Hi @Sriku ,

Total = [metric1] + [metric2] + [metric3] +[metric4]

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

[Sriku]

How to total, Can you please explain in logic. I am learner to Powerbi

[harshnathani]

Hi @Sriku ,

These metrics are Columns or measures.

What is the expected output. Your question is unclear.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490