Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Satish_Kumar
Helper V
Helper V

SUMMARIZE AMOUNT UNDER THE SAME NAME OF DIFFERENT ROWS

 

summer.png

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

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!

View solution in original post

14 REPLIES 14
CheenuSing
Community Champion
Community Champion

Hi @Satish_Kumar

 

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!

@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

 

 

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

 

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

Proud to be a Datanaut!

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

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

Proud to be a Datanaut!

@CheenuSing

its not working.

Its giving result like that

A1=X+Y

A2=X+Y

A3=X+Y

A4=X+Y

Hi @Satish_Kumar

 

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!

@CheenuSing

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

summer.png

@CheenuSing

This will make more clear to you i hope.

summer.png

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!

@CheenuSing

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

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!

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

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!

@CheenuSing

thanks 😄

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.