How to calculate row percentage

[Anonymous]

I have tried a few different formulas, but I am not able to just get the row percentage for each row. The end goal is to have the two rows displayed in a pie chart. The problem I am running into is that the percentage that it gives me is a total of the two rows, instead of dividing one row by the other. I would appreciate any help!

Thank you!

Attached are the two rows that I would like to get percentages for.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create measures

Measure = 
CALCULATE(SUM(Table1[Column1]),FILTER(ALL(Table1),[VDC Goal]="Current Employees"))

Measure 2 = 
CALCULATE(SUM(Table1[Column1]),FILTER(ALL(Table1),[VDC Goal]="Employee Hire Goal"))

Measure 3 =
IF(MAX(Table1[VDC Goal])="Employee Hire Goal",1,[Measure]/[Measure 2])

Best Regards

Maggie

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

[Greg_Deckler]

In the Fields area, click the little drop down next to the column and choose "Show As | Percentage of row" or Percent of total

[Anonymous]

I only have "Percentage of Grand Total" on the drop down menu.

Thank you for the reply!