Forum Discussion
Helper IItable doesnt sum correctly
Super UserHi munchkin666
Total in power bi doesn't summarize the visible values automatically.
You need to fix it "manually".Please refer to the linked tutorials :
https://www.youtube.com/watch?v=yw0QHu9V4UQ&t=773s
https://www.youtube.com/watch?v=O6qUiICLxLg
I answered a few days ago to question with a similar scenario including a sample pbix You can take a look here:
There is also the idea of Greg_Deckler about this issue, please vote for it :https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
- munchkin666
- Ritaf1983
Hi munchkin666
Please share some data to work with.Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- munchkin666
Ritaf1983 I am unable to add it, it keeps coming bakc with "your post has been changed because invalid html was found in the message body. the invalid html has been removed. please review the message and submit the message when you are satisfied.". I have tried to split the table, but its too big. Basically, I have lets say 3 groups:A,B,C. Group B didint have any data for 2022, but started to receive it in 2023. I did a calullation IF(ISBLANK(Result),50, Result/12). But for some reasons, PowerBI doesnt want to sum it in the totals. It only sums up A and B, although C (50) is listed there 😞
