weighted average - bad value

[Fidzi8]

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

[v-lili6-msft]

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/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

[amitchandak · Accepted solution]

@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.