count measure displaying negative values based on a clause

I’m trying to create this kind of visualisation, which counts the amount of scores by category, for every performance area (PA).

359c61b3-c779-494c-8f92-7fc578bb1167.png

With some sample data I’m currently trying to recreate this for our prototype dashboard, but I’m struggling with the negative counts.

2bfffaa0-8fbd-43e5-96ef-72353d1c17d3.png

Is there a possibility to set the ‘count’ measure to negative, based on a score (A - E), in this case the values in the pivot column?

0 0 363
0 REPLIES 0
Top Labels in this Space
Top Solution Authors