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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
plunkett40
New Member

Sum with multiple variables

I need some help being able to SUM this data Account Payable raw data in which has Invoice #, Inv Amount, GL Acct, Line Amount, Reviewer Group and OPS Center.  I always want to see how much cost by AP per each OPS Center.  I have attached a link to the raw date to see how I can do this.  

 

https://1drv.ms/x/c/dde426a4a83b9697/EQm4shm6t1VLth7P1C43fvUBp7YXyeJGUOV02fDTvhd9uA?e=YOPjPz 

 

ScreenshotScreenshot

1 ACCEPTED SOLUTION
BIDataRef
Frequent Visitor

Hi @plunkett40 

 

1. User Matrix visual, then use Pay Type(1st level), Ops Center(2nd level) in the rows, Inv. Date(or which ever date column deem necessary) in the Columns(select appropriate level of hierarchy - Year, Quarter, Month,Date), Inv. Amount as Values ( Aggregation - Sum). This will give you an output looking like the below - 

 

BIDataRef_0-1738198502715.png

2. If you need any specific summarized value, you can use the calculation as mentioned by @hnguy71 .

 

If I have solved your problem, mark my post as solution and give kudos 👍!!

Have a great day!

 

Thanks

 

View solution in original post

2 REPLIES 2
BIDataRef
Frequent Visitor

Hi @plunkett40 

 

1. User Matrix visual, then use Pay Type(1st level), Ops Center(2nd level) in the rows, Inv. Date(or which ever date column deem necessary) in the Columns(select appropriate level of hierarchy - Year, Quarter, Month,Date), Inv. Amount as Values ( Aggregation - Sum). This will give you an output looking like the below - 

 

BIDataRef_0-1738198502715.png

2. If you need any specific summarized value, you can use the calculation as mentioned by @hnguy71 .

 

If I have solved your problem, mark my post as solution and give kudos 👍!!

Have a great day!

 

Thanks

 

hnguy71
Super User
Super User

Hi @plunkett40 ,

It should just be the sum of your invoice or line item amount. If you only wanted to return the Accounts Payable value, your measure should look something similar to this:

AP.Total = CALCULATE(SUM(YOUR_FACT_TABLE[Inv Amount]), YOUR_FACT_TABLE[Pay Type] = "AP Payable")

 

Then you would plug that into a visual along with the "Ops Center" column and you should be able to see the required breakdown.



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.