AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • 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 3 years ago
1 Posts
1 Users
1 Reactions
1,312 Views
RSS
Brett Clark
Posts: 10
 Brett Clark
Topic starter
August 4, 2023 9: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,530 Topics
  • 11 K Posts
  • 12 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Negative/Credit Inventory Value?
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

  • Tim Rodman Johnny Tang
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.

‹›×

    ‹›×