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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
bslusarz
Regular Visitor

Measure to Calculate % of Total Salary by Project

Dear Power BI Community,

 

Our company general ledger has payroll data that has charged to various projects based on employee ID.  I am trying to find a DAX formula that will me to calculate the % of payroll time by Employee ID based on project filter criteria.  I am having a hard time figuring out how to do this.

 

Any suggestions?

Thank you,

Brian

 

 

2 REPLIES 2
Fowmy
Super User
Super User

@bslusarz 

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thank you.  Here is the Pivot Table in simplified format which summarizes our general ledger payroll data by project and employee.  The amounts are dollar amounts but for confidentiality, we would like to have the data presented as a % of employee's total payroll for a given month.  I'm pasting the Pivot Table and GL, not the actual PowerPivot Data but would appreciate guidance on any measures that could make this work.  Thank you!

 

bslusarz_0-1600805562206.png

 

bslusarz_1-1600805597784.png

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Kudoed Authors