Problem with SUMMARIZE

[Jan91]

Hey there,

i hope i could get any help here 🙂

There are a table with different production data. Each production could be identified by an unique OrderNr. Because there are a lot of bookings for each OrderNr i tried to create a SUMMARIZE table.

SumTable = SUMMARIZE('ProductionData', 'ProductionData'[OrderNr]) 

That works fine and i can implement a relationship between both tables by using the OrderNr as an identifier.

The problem starts as soon i try to add addition data from productionData to SumTable - for example productionTime.

For this i use the following formula:

SumTable = SUMMARIZE('ProductionData', 'ProductionData'[OrderNr],'ProductionData'[productionTime]) 

As soon i try this, i get an error because of duplicat values in SumTable.

Am i the problem or is there are known problem with SUMMARIZE function?

Thank you very much for your help and please excuse my english skills 🙂

[bhanu_gautam]

@Jan91  Try updating measure as 

SumTable =
SUMMARIZE(
'ProductionData',
'ProductionData'[OrderNr],
"TotalProductionTime", SUMX(CURRENTGROUP(), 'ProductionData'[productionTime])
)

[Jan91]

@bhanu_gautam thank you for your quick answer!

I tried this solution but it doesn´t worked unfortuantely. But it inspired me for new approaches!

Instead i solved this problem by adding calculated columns to SumTable. Now it works as i expeted.

Thank you very much!

[bhanu_gautam]

@Jan91 , That's awesome