Forum Discussion
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
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.
2 Replies
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.
hi Fidzi8
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/63376Also
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
