cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CTan42 Helper II
Helper II

sum of revenue regard with its source and type

Hi, belows are my screenshot of my dataset. I'm asked to create a measure to calculate the sum of the revenue of each region regard to it's source and type. So i will put this measure as the value in the matrix table. Is there anyway to do this?  By doing this measure, so i wont have to create a slicer for the source and type?

image.pngexcel dataimage.pngpower biimage.pngmatrix table

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User I
Super User I

Re: sum of revenue regard with its source and type

@CTan42 so are you saing you want to  hard code each measure by source and type?

 

ie. 

 

A AR Revenue = calculate(sum(revenue), source = "a", type = "AR")

 

?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

View solution in original post

CTan42 Helper II
Helper II

Re: sum of revenue regard with its source and type

@vanessafvg yes i am. so is that the solution?

 

View solution in original post

4 REPLIES 4
Super User I
Super User I

Re: sum of revenue regard with its source and type

@CTan42 so are you saing you want to  hard code each measure by source and type?

 

ie. 

 

A AR Revenue = calculate(sum(revenue), source = "a", type = "AR")

 

?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

View solution in original post

CTan42 Helper II
Helper II

Re: sum of revenue regard with its source and type

@vanessafvg yes i am. so is that the solution?

 

View solution in original post

Super User I
Super User I

Re: sum of revenue regard with its source and type

@CTan42  that would be the correct way to create the measure, is there a lot of measures to create?

 

how will you display the data, what do you want to do with it?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Highlighted
CTan42 Helper II
Helper II

Re: sum of revenue regard with its source and type

@vanessafvg thx for your help...it works! So basically i will create few matrix tables to display each source & type revenue. Tbh this is just a fake data. My real data is bigger size than these screenshot shown. Thanks your help again.

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors