scatter chart data aggregation issue

[Asim]

Good Morning,

I have been facing issue while creating scatter chart in my report.

I created a scatter chart in my report and it was showing correct result with machines but when i created a hierarchy which include machines and their capacity group then the quantity produced appearing as an average instead of sum.

for example, I have extrusion as capacity group and there are three machines involve in this process.

the total output km/hr of this group is (9.83+30.35+31.19) = 71.37 km/hr but in the chart it just shows the average = 23.79

whereas by drilling down it shows the correct output of all 3 machines.

How i can get a total value of these three machines in the capacity group

Any solution to overcome this issue,

Best Regards

Asim

[Greg_Deckler]

You should be able to change the aggregation type if you click the drop down arrow on the field. But tough to say without source data, formulas and such.

[Asim]

Good Morning @Greg_Deckler

I am using below mentioned measure to calculate the output km/hour of each machine.

Output Km/Hr =
calculate (
SUM(PL[Act. Quant. Prod.]),
TREATAS(values(Eventlog[Machine]),PL[Machine])) / 1000 / ( [Total Loading time] / 60 )

As this is measure, hence the dropdown list is not available in the field pane.

Do I need to make some changes in measure.

Please suggest!

Regards

Asim

[v-yuezhe-msft]

@Asim,

It seems that the measure re-calculates in different levels. Could you please share sample data of your table for us to test?

Regards,
Lydia

[Asim]

Dear @v-yuezhe-msft

I am using multiple tables to access the data, kindly provide your email address so that i could send the full file.

I have created two measures to calculate output km/hr of the machine, these measures works very well at machine level but  when i use the hierarchy feature like capacity group on top of machines then system just provide average of output km/hr.

Output Km/Hr =
calculate (
SUM(PL[Act. Quant. Prod.]),
TREATAS(values(Eventlog[Machine]),PL[Machine])) / 1000 / ( [Total Loading time] / 60 ) 

Total Loading time = sumx(Eventlog,IF(Eventlog[Event]="production",Eventlog[Duration]+Eventlog[TK1]+Eventlog[TK2]+Eventlog[TK3]+Eventlog[TK4],Eventlog[TK1]+Eventlog[TK2]+Eventlog[TK3]+Eventlog[TK4]))