Charticulator vs Matrix - average of the source data

[Henrik_99]

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.

 

[Henrik_99]

Thanks Stephen:)

[v-stephen-msft]

Hi @Henrik_99 ,

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.

[Henrik_99]

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 %

[v-stephen-msft · Accepted solution]

Hi @Henrik_99 ,

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.