Forum Discussion

Asim's avatar
Asim
Helper I
8 years ago

scatter chart data aggregation issue

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 hier...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
Asim
Helper I
8 years ago

Dear Anonymous

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]))