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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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?

excel dataexcel datapower bipower bimatrix tablematrix table

2 ACCEPTED SOLUTIONS
vanessafvg
Super User
Super User

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

 

?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

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

 

View solution in original post

4 REPLIES 4
vanessafvg
Super User
Super User

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

 

?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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

 

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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




@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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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