Forum Discussion

aschillinger20's avatar
aschillinger20
Icon for Helper II rankHelper II
6 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
    6 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
Icon for Community Champion rankCommunity Champion
6 years ago

aschillinger20 - Use SUMMARIZE perhaps:

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

Greg_Deckler 

 

First; thank you for your help and patience. I seem to be struggling pretty hard on this one. To clarify; my "Production Hours" column is labled "P21_Hour_Qty", my table is called "Production data"

 

Here is my formula: 

 

Measure = SUMX(SUMMARIZE('Production data',[prod_order_number],"_PRODUCTION HOURS", MAX([P21_hour_qty]),[_PRODUCTION HOURS]))
 
I'm getting a too few arguments error.