Charticulator vs Matrix - average of the source data

Hi Anonymous ,

You may try this measure.

Measure = var _cost=CALCULATE(SUM('Table'[Cost]),ALLEXCEPT('Table','Table'[System]))
var _budget=CALCULATE(SUM('Table'[Budget]),ALLEXCEPT('Table','Table'[System]))
return 
IF(ISINSCOPE('Table'[Area]),SUM('Table'[ %]),DIVIDE(_cost,_budget))

I have the subtotals in the matrix showing the mean.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.