Weighted Average Formula not working ?

[Anonymous]

Hi all,

When I make my calculation in Excel for the weighted average, I get a different % for the risk assessment in BI.

It should be 92,3% and I am getting 114,1%. Which is already strange because it should not be above 100%. 

What am I doing wrong?  I checked my base data and I see nothing strange. And what it even more strange, is that all other categories are correct, only the risk assessment category is wrong. 

[tamerj1 · Accepted solution]

Hi @Anonymous 

please try

=
DIVIDE (
    SUMX (
        'databestand',
        'databestand'[Score in %] * 'databestand'[Aantal dossiers getoetst]
    ),
    SUM ( 'databestand'[Aantal dossiers getoetst] )
)

[Anonymous]

My godddddddddddd... you know how much time I have wasted on this🤣🤣🤣

GOD BLESSS YOUUUUUUUUUUUU....... 

I you were here in my neighbourhood I would have brought you a box of chocolates..... Thank you soooooooo much. 

I knew something had to be wrong with the formula, but we used the quick measure for BI and thought that it had setup the correct formula. 

[Anonymous]

weightage avg = 

SUMX(category_values,table[score 1%] * table[antal]) / [Total antal]