Sum of column - Incorrect in table/matrix

[Tevon713]

Hi all,

Have a simple problem, can't seem to figure it out why it summing incorrectly. I want to just display the calculated measure in a table format ie pic #2 with correct sum.

MEASURE:   Cal Time per Event = SUM (Time per Event)

Correct when the "Time per Event" column is in table and not summarizing sum function.

BUT when I remove that column giving me incorrect sum. 

Then I tried to do quick summarize of sum of that column it give me matching that of  the measure.

[Idrissshatila · Accepted solution]

Hello @Tevon713 

Check this article from SQLBI it may help you with your case https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/

If I answered your question, please mark my post as solution, Appreciate your Kudos👍

Follow me on Linkedin

[Tevon713]

Thanks @Idrissshatila. I finally figured it out.