Forum Discussion

Helper V

6 years ago

Solved

weighted average - bad value

Hi, before last days I need help with weighted average. I calculate this value but I don´t know one row - why is 0,99? Thank you Ondřej

Tips and Tricks

amitchandak
6 years ago
Fidzi8 , Can you check what value you are getting for the sumx in divide. Get that a separate column and check. If you still see issue.Can you share sample data and sample output.

Community Support

6 years ago

It seems that there is something wrong in the SUMX Function calculated.

See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[Trips] and [Priorita] are from different tables, if the row context of this table visual is all from sheet1 table?

and if you adjust the formula as below to see if it works well

Weighted average = DIVIDE(SUMX(Sheet1; CALCULATE(SUM(Sheet1[Trips]))*'Inyern'[Priorita]); SUM(Sheet1[Trips]))

If not your case, please share a simple sample pbix file for us have a test.

Regards,

lin