Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
@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 ,
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)
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)
How 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
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |