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), correct is 38% (=6713/ 17554 (source data).
any idea ? Thanks./ H.
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.
4 Replies
Hi Anonymous ,
If you want to get 38%, then your formula has to calculate the numerator of KE plus the numerator of KI, divided by the denominator of KE plus the denominator of KI.
Is it possible to provide some dummy data and expected results?
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.