Forum Discussion
Solved
How do I set up this calculation
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()...
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)))
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.
Thanks, but that gives an error