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

 

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

 

 

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