Forum Discussion

Jan91's avatar
Jan91
Regular Visitor
2 years ago

Problem with SUMMARIZE

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 🙂

 

Need Help

3 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    Jan91  Try updating measure as 

     

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

    • Jan91's avatar
      Jan91
      Regular Visitor
      2 years ago

      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!