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.

     

rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago

Hello Shamatix,

I assume you're plotting 'B' column in the visualization. Please right click on the column in Fields Pane and click on "Don't summarize".

Shamatix's avatar
Shamatix
Post Partisan
6 years ago

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

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    6 years ago

    Shamatix,

     

    Can you please share your expected results again? I am unable to understand you.

      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi Shamatix ,

        I  think this is by design, if there is no unique id, it will show value as a group when you use aggregation or you will see all value but no total value. So I think current workaround is that you add an unique column before. 

        let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlTSUTJUitWBsIzArCQgywTMSoaLpUDUxQIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [name = _t, amount = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"name", type text}, {"amount", Int64.Type}}),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1)
in
    #"Added Index"

         By the way, you also could submit this  requirement in power-bi-ideas   

        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.