Forum Discussion
Charticulator vs Matrix - average of the source data
Hi, it seems that Charticulator calculate the average of the data behind the visuals and not the values of the source data. Example - 58% is the average of 80% (742/932) and 36% (5971/16622), c...
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.
Hi Stephen,
Here is the expected outcome and dummy data
38% is based on Cost/Budget
Secondly if you drillthough on right bar chart 17 554 it does not give me the expected outcome. However if you rightclick on 80% then it does. Any thoughts?
Rgds Henrik
| Item | Area | Cost | Budget | System | % |
| A1 | KE | 742 | 932 | OG | 80 % |
| A2 | KI | 5971 | 16622 | OG | 36 % |
| A2 | KI | 344 | 1037 | MG | 33 % |
| A4 | KE | 1077 | 1431 | MG | 75 % |
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.