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 multiplicati...
DAX Calculation
DAX Commands and Tips
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