Calculated column for weighted average does not work for few rows

Question

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.

fowmy · Answer

Avivek&nbsp;Try:Weight(measure)= CALCULATE(SUMX(RECEIVABLES,RECEIVABLES[Days Diff]* RECEIVABLES[PAYMENT_AMOUNT]))________________________Did I answer your question? Mark this post as a solution, this will help others!.Click on the Thumbs-Up icon if you like this reply 🙂YouTube, LinkedIn&nbsp;

fowmy · Answer

Avivek&nbsp;The measure works for me, please check your model and the data.&nbsp;________________________Did I answer your question? Mark this post as a solution, this will help others!.Click on the Thumbs-Up icon if you like this reply 🙂YouTube, LinkedIn&nbsp;

fowmy · Answer

Avivek&nbsp;I am not sure how you have adapted the measure. The Weighted Measure (New) is calculating and dividing it by 2 I believe.&nbsp;________________________Did I answer your question? Mark this post as a solution, this will help others!.Click on the Thumbs-Up icon if you like this reply 🙂YouTube, LinkedIn

fowmy · Answer

Avivek&nbsp;It's hard to make a conclusion unless having a look at your PBIX file, you may share the file removing any confidential information to check.ThanksFowmy

avivek · Answer

Thankyou&nbsp;Fowmy&nbsp;, but this measure does't work, it gives the same issue like the calculated column&nbsp;

Forum Discussion

Calculated column for weighted average does not work for few rows

9 Replies

Related content

Calculating Weighted Average

Calculating Weighted Sales

Weighted Average DAX

calculating weighted average

weighted average calculation