cancel
Showing results for
Did you mean:
Helper V

SUMMARIZE AMOUNT UNDER THE SAME NAME OF DIFFERENT ROWS

I WANT THE SUM OF AMOUNT UNDER A SAME .

i.e. for four name i have only four record in new table with their sum of amount.

1 ACCEPTED SOLUTION
Community Champion

Here you go

Table = SUMMARIZE( '15-16','15-16'[SBU], "Summary", Sum('15-16'[Value]) )

Now plot the SBU and Summary

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
14 REPLIES 14
Community Champion

Please provide more details about the data model, data and the output expected.

Cheers

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Helper V

basically i have to summarize of the basis of SBU code.

let assume that we have four SBU Like A1,A2,A3,A4.

and regarding to this SBU  we have multiple transaction, but at the end i want to see the total amount of transaction of each SBU.

A1-XXXXXXXXX

A2-XXXXXXXXXX

A3-XXXXXXXXXXXXXXX

A4-XXXXXXX

Community Champion

Simply create a measure SUmTrans = sum(yourtablename[ColumnName])

Use this and SBU as values in a table chart and check.

If this wroks for you please accept this as solution and also give KUDOS.

Cheers

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Community Champion

Create a measure called SumTrans = sum(yourtablename[columnname])

Now plot a table chart using

SBU and the above measure SumTrans

If this works for you please accept it as a solution and also give KUDOS.

Cheers

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Helper V

@CheenuSing

its not working.

Its giving result like that

A1=X+Y

A2=X+Y

A3=X+Y

A4=X+Y

Community Champion

Share the expression you had created and also some sample data to explore

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Helper V

@CheenuSing

I want to summarize the amount(values) under these SBU.

Helper V

@CheenuSing

This will make more clear to you i hope.

Community Champion

can you send the expression used for the measure Summarize in your data model

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Helper V

@CheenuSing

Table = SUMMARIZE('15-16','15-16'[SBU],'15-16'[Value])

Community Champion

Looks like you are creating a summry table.

There is no need for this, unless you have specific reasons to do .

Just create a measure in your '15-16' table

sumTrans = sum('15-16[Value])

Now try plotting.

Cheers

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Helper V

@CheenuSing

I have to create the summary table beacause i have to compare the total amount of last year to this year.

So it necessary for creating that.

So if you help me out for doing that i will be pleased.

Community Champion

Here you go

Table = SUMMARIZE( '15-16','15-16'[SBU], "Summary", Sum('15-16'[Value]) )

Now plot the SBU and Summary

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Helper V

@CheenuSing

thanks 😄