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(),
CALCULATE(MAX(Subcategories[Weighting])*SUM('Supplier Evaluation'[Score]))/100)
Can anybody help?
Br
Lotte
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)))
3 Replies
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
