Forum Discussion
Counting aggregated score in a visual
This is probably very simple but I am struggling with it. For each Vendor Identified below, they have several lines of POs and have flagged Yes/No for On time to determine "On Time Lines" in clolumn E below. I then created a measure to calculate the aggregate score. I would like to now count the # of vendors who have a score of 80% and above (those in GREEN) vs those in RED.
Help please?
Please try an expression like this. I assume you would put this is a Card visual (or some visual that doesn't have Vendor # in it).
Count Vendors Over 80% =
COUNTROWS (
FILTER ( VALUES ( Table1[Vendor#] ), [Aggregate Score(%)] >= 0.80 )
)For comparison, you could put that into a variable, use same expression with < 0.80 for your red count, and then divide them (or do some other comparison) in the "return" of your expression.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
2 Replies
- mahoneypat
Microsoft Employee
Please try an expression like this. I assume you would put this is a Card visual (or some visual that doesn't have Vendor # in it).
Count Vendors Over 80% =
COUNTROWS (
FILTER ( VALUES ( Table1[Vendor#] ), [Aggregate Score(%)] >= 0.80 )
)For comparison, you could put that into a variable, use same expression with < 0.80 for your red count, and then divide them (or do some other comparison) in the "return" of your expression.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Thank you, This works very well!
