Forum Discussion

aschillinger20's avatar
aschillinger20
Helper II
5 years ago
Solved

Distinct sum based on unique value

I have some production data that duplicates when another user signs into an order. Here is a basic examaple:   Productction Order Number   |   Production Hours 1001                                ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    aschillinger20 - Sorry man, missed a paren placement.

    Measure = SUMX(SUMMARIZE('Production data',[prod_order_number],"_PRODUCTION HOURS", MAX([P21_hour_qty])),[_PRODUCTION HOURS])

    That should be the right one. 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

aschillinger20 - Use SUMMARIZE perhaps:

Measure = SUMX(SUMMARIZE('Table',[Production Order Number],"__Production Hours",MAX([Production Hours]),[__Production Hours])
aschillinger20's avatar
aschillinger20
Helper II
5 years ago

amitchandak 

 

the first option you provided seems to be taken the higest number of hours from all production orders and assigning that number to all production orders. How do i get it to sum the highest production hours by specific production order to sum? 

 

Greg_Deckler 

 

I think we're on the same page, i'm just struggling to follow the formula.