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)))
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)
))