AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica OData wit...
Power BI Measure to...
 
Notifications
Clear all

Questions Power BI Measure to Calculate Sales for a Specific Department

 
Acumatica OData with Microsoft Excel and Power BI
Last Post by Brett Clark 2 years ago
1 Posts
1 Users
1 Reactions
1,276 Views
RSS
Brett Clark
Posts: 10
 Brett Clark
Topic starter
August 4, 2023 8:00 am
(@bclark)
Eminent Member
Joined: 3 years ago

Hi all, 

I'm working in Power BI using OData feed from Acumatica. I'm pulling in sales data from Acumatica, and trying to connect it to payroll departments. 

I want to show the sales and payroll $ for each department. The conditions are that if the department creates their own sales, they are only compared against their own sales. If they do not make sales (like an Admin department), then they are compared against total company sales. And I was able to accomplish this with the following measures. 

image
image
image

 

However, I have been asked to show the sales for our "Packing" department against only a few specific order types. I thought adding something like this would work: 

image

But instead it just leaves the Packing department blank. 

image

 

Any thoughts on how I could do this? 

Thanks!

 


Tim Rodman reacted
Topic Tags
Power BI
Forum Jump:
  Previous Topic
Next Topic  
Topic Tags:  Power BI (3) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,527 Topics
  • 10.9 K Posts
  • 28 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • amassey
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×