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 - Usually it is the other way around. Can you give me a better sample data set and I'll test?