Forum Discussion
Counting aggregated score in a visual
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
Microsoft EmployeePlease 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!
