How do I set up this calculation

[LotteLaugesen]

Hi

I need to sum the Weighted Sub in the Subcategory within the Category:

So for Commercial it should be 78.
The weighted sub calculation:

Weighted Sub =

IF(ISINSCOPE(Areas[Area]),BLANK(),

CALCULATE(MAX(Subcategories[Weighting])*SUM('Supplier Evaluation'[Score]))/100)

Can anybody help?
Br
Lotte

[LotteLaugesen · Accepted solution]

I found a way of doing it 😀

Total per Category =

IF(ISINSCOPE(Areas[Area]),BLANK(),

SUMX (

  VALUES (Subcategories[Subcategory]),

  CALCULATE((MAX(Subcategories[Weighting])*SUM('Supplier Evaluation'[Score]))/100)

))

[moncx]

Hey, I don't know in what table you store Category value so change that in a measure but you can try something like this:

CALCULATE(
SUM(MAX(Subcategories[Weighting])*SUM('Supplier Evaluation'[Score]))/100),
ALLEXCEPT('YourTable', 'YourTable'[Category])
)

Hope it helps!

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[LotteLaugesen]

Thanks, but that gives an error