Measure to Calculate % of Total Salary by Project

[bslusarz]

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

[Fowmy]

@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

[bslusarz]

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!