Forum Discussion

analyticspbi87's avatar
analyticspbi87
Helper I
1 year ago
Solved

Weighted Average while filtering out another column

I was trying to make a chart from the data as follows with the filter on category = A  Category Name Year Value  Health  Class Class 2 A Celery 2025 14                               ...
Need Help
vicky_'s avatar
vicky_
Super User
1 year ago

Here's my measure: 

Cam calc = DIVIDE(
    SUM('Table'[ Health ]) * SUM('Table'[Value]),
    CALCULATE(SUM('Table'[ Health ]), REMOVEFILTERS('Table'[Class]))
)

and the result (ignore the Sum of Value column):

 

btw - I can't get the same results as your example (I just filtered by Category = A; why would Asparagus not be included in the Cam calc measure in the veg subtotal? you might need to change the calculate parameter depending on your specific requirements)