Forum Discussion

Shamatix's avatar
Shamatix
Post Partisan
6 years ago
Solved

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...
Need Help
Show and Tell
  • dax's avatar
    dax
    6 years ago

    Hi Shamatix , 

    There is no method could achieve this directly. So one workaround is that you could show detail data in table and show total in Card like below

    Best Regards,
    Zoe Zhi

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

     

amitchandak's avatar
amitchandak
Super User
6 years ago

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/823601

  • Shamatix's avatar
    Shamatix
    Post Partisan
    6 years ago

    Well 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.