Counting aggregated score in a visual

[RDzeketey]

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?

[mahoneypat · Accepted solution]

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

[RDzeketey]

Thank you, This works very well!