Forum Discussion

Avivek's avatar
Avivek
Icon for Post Partisan rankPost Partisan
6 years ago

Calculated column for weighted average does not work for few rows

I had created a calculated column for total weight calculation which was (days difference* payment recieved). This calculated column works fine for few rows fetching the correct value on multiplication but few rows the multiplication values do not match. let me share the screenshot for it:

 

 

The calculated column is ,

Weight = RECEIVABLES[Days Diff]*RECEIVABLES[PAYMENT_AMOUNT]
 
Since it did not fetch the value I needed I created a new measure
Weight(measure)= CALCULATE(SUMX(RECEIVABLES,RECEIVABLES[Days Diff]*VALUE(sum(RECEIVABLES[PAYMENT_AMOUNT]))))
 
Though the measure works well but then the issue is that the total is not correct.
I need the total weight for another measure to fetch  me the weighted average days.
DAX Calculation
DAX Commands and Tips

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Avivek , try

    Weight(measure)= CALCULATE(SUMX(RECEIVABLES,RECEIVABLES[Days Diff]*RECEIVABLES[PAYMENT_AMOUNT]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Avivek ,

     

    Can you share a screen shot or some sample data of your solution.

     

    Try

    Weight(measure)= SUMX(RECEIVABLES,RECEIVABLES[Days Diff]*RECEIVABLES[PAYMENT_AMOUNT]))

     

    or 

    Weight = SUMX( SUMMARIZE(Receivable, Receivable[Day Diff], Receivable[Payment_Amunt]), RECEIVABLES[Days Diff]*RECEIVABLES[PAYMENT_AMOUNT]))

     

    Regards,

    Harsh Nathani