topic Re: How do I set up this calculation in DAX Commands and Tips

How do I set up this calculation

LotteLaugesen — Fri, 20 Sep 2024 07:00:18 GMT

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

moncx — Fri, 20 Sep 2024 07:11:13 GMT

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 — Fri, 20 Sep 2024 08:26:21 GMT

Thanks, but that gives an error

LotteLaugesen — Fri, 20 Sep 2024 09:32:26 GMT

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)

))