sum of revenue regard with its source and type

[CTan42]

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

[vanessafvg · Accepted solution]

@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")

?

[vanessafvg · Accepted solution]

@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")

?

[CTan42 · Accepted solution]

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

[vanessafvg]

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

[CTan42]

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