Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with Measure to summarize multiple rows (picture included)

Hi,   I'm trying to write a measure in PowerBI that will make the items on the left summarize in to a format that will look like the items on the right. Is there an easy way to do this?    ...
Need Help
Tips and Tricks
  • ManguilibeKAO's avatar
    ManguilibeKAO
    4 years ago

    Hi Ryanh,

    Here's a solution:

    Create a table named TableB, with the following formula:

    Table B=SUMMARIZE('TableA','TableA'[Name],"Balance",SUM('TableA'[Balance]))

     

    Note that I have assummed that TableA is the name of the table containing the input data.

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

     

    Manguilibe KAO

ManguilibeKAO's avatar
ManguilibeKAO
Icon for Resolver I rankResolver I
4 years ago

Hi Ryanh,

Here's a solution:

Create a table named TableB, with the following formula:

Table B=SUMMARIZE('TableA','TableA'[Name],"Balance",SUM('TableA'[Balance]))

 

Note that I have assummed that TableA is the name of the table containing the input data.

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

 

Manguilibe KAO