Forum Discussion
Missing rows when using SUM
Hi fellow users of Power Bi,
I have a table lets say it contains 3 colums A, B and C and has the Following Values
A |B |C
Bo|1 |0
Bo|1 |0
Kik|2|3
-------
|4|3
But today in power bi when I use a "SUM" it shows it as follows:
A |B |C
Bo|2 |0
Kik|2|3
-------
|4|3
I Know I can add a unique ID column to the table and that it will turn out correctly and show ALL the rows, but I find it to be an ugly solution. How can I have it shows the totals at the bottom AND all the rows, without making some "Hack solution" if you get me 🙂
Best regards
9 Replies
What should Actually it display.
If you are looking for B =3
Try this
sumx(summarize(table,table[A],"_B",max(table[b])),[_B])Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Well I want it to continue showing the total at the bottom of the table, so the total is correct.
My issue is that when you use a SUM on a column and the rows dont have a "Unique" value it hides some of the rows.
If you use dont summarize I do not get the Total of the column at the bottom of the table which I want to have, but when I have "Sum" on, it hides some of the rows if I do not have a unique value..
