Forum Discussion
Helper IVBucket 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 |
| 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 |
5 Replies
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)- amitchandak
Super User
Sriku , how come are Metrics has the same name Metrics1
You can create a new measure
Total = sumx(Table,[Metrics1] +[Metrics2]+[Metrics3]+[Metrics4])
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)
SrikuHow to total, Can you please explain in logic. I am learner to Powerbi
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
