Problem with the Average total line of a table

[Anonymous]

Hello people,

I`m trying to calculate the right total number for a table.
Currently I get the correct scores on each row but the total score is of by 0.03666 (or rounded off -0.1).

This is the formula I`m currently using:

# 2D - faciliteiten = 

    CALCULATE(

            AVERAGEX(Fact_Instellingsvragen,Fact_Instellingsvragen[Antwoord])

            ,Fact_Instellingsvragen[Vraag]="HANZE02B")

And this is the table:

I`m have already tried the method to make a totals measure but it gives back the same result.
The formula for this measure is:

m_Total 1 =

VAR __table = AVERAGE('Fact_Instellingsvragen', [School], "__value", [# 2D - faciliteiten])

RETURN

IF(HASONEVALUE(Fact_Instellingsvragen[School]),[# 2D - faciliteiten],SUMX(__table,[__value]))

What I`m doing wrong that Power BI thinks that the total is 7.6228 and not 7.6594 (3867.985/505) ?

Any advice is welcome and thank you in advance.

Jeroen

[Anonymous]

Hello Winniz,

Thank you for your reply. It turned out to be something else (a problem with a join).

This question/topic can be closed.

Best regards,

Jeroen

[v-kkf-msft]

Hi @Anonymous ,

If you have solved your problem, kindly Accept it as the solution to help the other members find it more quickly.

Best Regards,
Winniz

[v-kkf-msft]

Hi @Anonymous ,

Not sure about your model, maybe you can try the following formula to see if it returns the correct result.

Measure = 
CALCULATE(
    SUM(Fact_Instellingsvragen[Antwoord]) / COUNTROWS(Fact_Instellingsvragen)
    ,Fact_Instellingsvragen[Vraag] = "HANZE02B"
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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