cancel
Showing results for
Did you mean:
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?

excel datapower bimatrix table

2 ACCEPTED SOLUTIONS

Accepted Solutions
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")

?

Proud a to be a Datanaut!
Helper II

## Re: sum of revenue regard with its source and type

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

4 REPLIES 4
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")

?

Proud a to be a Datanaut!
Helper II

## Re: sum of revenue regard with its source and type

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

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?

Proud a to be a Datanaut!
Highlighted
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.

Announcements

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

And the winner is...

#### Announcing the New Spanish Forum

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

#### 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

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors