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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Calculate percentage from same column

Hello,

 

I was wondering if there is a way to calculate the percentage of a value in a column based on a different value in the same column. To do this I'd like to use a different column as an index.

For instance, on the attached picture, I would like to calculate the percentage of Total Labor on Total Cost.

 

Thanks for your time.

Capture8321412.JPG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hello @Anonymous

 

Try this please:

 

Percentage= DIVIDE(CALCULATE(SUM(Table[Month Budget]);FILTER(Table;Table[Category]="Total Labor"));CALCULATE(SUM(Table[Month Budget]);FILTER(Table;Table[Category]="Total Cost")))

 

I hope this works.

 

PS, in "Table", you've to put the name of the table.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hello @Anonymous

 

Try this please:

 

Percentage= DIVIDE(CALCULATE(SUM(Table[Month Budget]);FILTER(Table;Table[Category]="Total Labor"));CALCULATE(SUM(Table[Month Budget]);FILTER(Table;Table[Category]="Total Cost")))

 

I hope this works.

 

PS, in "Table", you've to put the name of the table.

Anonymous
Not applicable

Sorry, I didn't fully explain my situation. I have dozens of clients and every client has those 5 rows with a client ID. Your solution, while elegant, it will only work if there was only one set if clients.

 

I ended up splitting the table into 5 smaller tables each containing one category and then doing calculations that way. I know it's not clean.

Hi @Anonymous

 

It seems you may use "Append Queries" in query editor to combine the tables. Then you may use the measure as HarrisonCbe mentioned. If it is not your case, please share sample data for your scenario so that we could help further on it.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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