SUMMARIZE AMOUNT UNDER THE SAME NAME OF DIFFERENT ROWS

[Satish_Kumar]

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.

[CheenuSing]

Hi @Satish_Kumar

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

Cheers

CheenuSing

[Satish_Kumar]

@CheenuSing 

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

[CheenuSing]

Hi @Satish_Kumar

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

[CheenuSing]

Hi @Satish_Kumar

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

[Satish_Kumar]

@CheenuSing

its not working.

Its giving result like that

A1=X+Y

A2=X+Y

A3=X+Y

A4=X+Y

[CheenuSing]

Hi @Satish_Kumar

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

[Satish_Kumar]

@CheenuSing

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

[Satish_Kumar]

@CheenuSing

This will make more clear to you i hope.

[CheenuSing]

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

[Satish_Kumar]

@CheenuSing

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

[CheenuSing]

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

[Satish_Kumar]

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

[CheenuSing · Accepted solution]

Here you go

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

Now plot the SBU and Summary

[Satish_Kumar]

@CheenuSing

thanks 😄