Solved: How to calculate a % of total based on specific Fi... - Page 2

jaynesa · ‎03-20-2020

I have table, with columns for Account Code, Organization, Location, Category, Year, and Payroll Sum. I would like to create a % of Total of Payroll, by Location filtering on year, category, and organization. I tried doing this a multitude of ways but nothing is working! How do I execute this properly in Power BI?

amitchandak · ‎03-20-2020

@jaynesa

Try

divide(
calculate(sum(table[payroll Sum])),
calculate(sum(table[payroll Sum]),ALLEXCEPT(table,table[category],table[year]))
)

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

How to calculate a % of total based on specific Filters

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly