Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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:
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
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
99 | |
81 | |
76 | |
66 |
User | Count |
---|---|
134 | |
108 | |
104 | |
83 | |
73 |