SUMMARIZE TABLE NOT SHOWING ALL DATA

[marciomendonca]

Good afternoon, community, here's my problem. I want to be able to, daily, save a specific table from Power Bi on Excel, the thing is when I try to directly copy it to Excel, the table gets all messed up and out of order, so to  go around this issue I decided to create a summarized version of the bigger table and, apparently, worked just fine. But then, when I started doing some math using the values of the summarized table, the calculation simply didn't match.

The expected value (SUM executed on the values of the bigger table)

Value that I get when SUMMING the values of the summarized table

1829 lines on the bigger table

Only 1769 lines on the summarized table

And here was how I created the summarized table. Only using the SUMMARIZE function (originally, I had also used the the CALCULATETABLE function to filter only the type of data that I was looking for, but I removed to see if that was the problem and, apparently, it wasn't)
Any help? What did I do wrong?

Many thanks in advance!

[v-xiaotang · Accepted solution]

Hi @marciomendonca 

Thanks for reaching out to us.

according to your description, it may be related with Context, please use all() function when you sum the total of the summarized table

for example, 

preco_a_cobrar_measure = SUMX(ALL(SALVAR_DIARIAMENTE),[preco_a_cobrar])

FYI: ALL function (DAX) - DAX | Microsoft Learn

Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table.

Best Regards,

Community Support Team _Tang

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

[parry2k]

@marciomendonca very hard to answer with the details you provided.

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490