Forum Discussion

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

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...
General Comment
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Avivek ,

     

    You may create a new measure like DAX below to get the correct total.

     

    Weight(measure)_New=

var _table = SUMMARIZE(RECEIVABLES, RECEIVABLES[Month & Year],"_Value", [Weight(measure)] )

return
IF(HASONEVALUE(RECEIVABLES[Month & Year]), [Weight(measure)], SUMX(_table,[_Value]))

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Avivek , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Multiplication should be done at row level and division at aggregated level

 

 

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

amitchandak , please find the link-

But this file I have taken it from the excel after filtering the confidential part but i do not see the total issue in the measure here but I can see that issue in the report when it is connected to the model, let me share the screenshot with the same data from the report connected to the model
 
-