Sum issue

[FRG]

Hi,

In this table visual I get these values. It's basically a volume, a duration in hour and a volume per hour who is calculated with this measure: 

PmpH = SUMX('13021sorter prodboard (2)';'13021sorter prodboard (2)'[boardFeet]) / [ProdHour]

Each row is for a period of time.

If I remove the periods of time, boardfeet and ProdHour:

  

Now, I get the average for each station and the average of the 2 values in the Total row.

1. I want a formula that take the ProdHour ratio to calculate it. It will not necessary be the average. In the case of Station 1 the expecting result should be around 2025. 

2. I want the total of the 2 values (result for station 1 + result for station 2)

Thanks for your help!

[TeigeGao]

Hi @FRG ,

Could you please tell us how can we get the result 2015, (9175++2476)/(4.4+1.5) = 1975. Please share the expression to us.

Best Regards,

Teige

[FRG · Accepted solution]

Sorry my friends, I had a bad understanding of the things. The result is correct.

And for question #2, I create a measure:

CALCULATE(SUMX('13021sorter prodboard (2)';'13021sorter prodboard (2)'[boardFeet])  / SUMX('13021sorter prodruntime_gradingchain (2)';'13021sorter prodruntime_gradingchain (2)'[ProdHour]);FILTER('13021sorter prodboard (2)';'13021sorter prodboard (2)'[Station] = 1))
            +
            CALCULATE(SUMX('13021sorter prodboard (2)';'13021sorter prodboard (2)'[boardFeet])  / SUMX('13021sorter prodruntime_gradingchain (2)';'13021sorter prodruntime_gradingchain (2)'[ProdHour]);FILTER('13021sorter prodboard (2)';'13021sorter prodboard (2)'[Station] = 2))

Thanks.