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...
Need Help
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!