Create a pie chart where the Expenses are displayed as a % of Revenue - Repost

[ChrisAZ]

Unfortunately, only a few people responded previously, and they have not come back to follow up so I am left stuck and hoping some others might be able to help.

So I am going to try to explain this as clearly as possible, but essentially, I want to create a pie chart that displays the different expenses categories as a % of the total revenue value. Said another way, the "100%" value of the pie chart would be the revenue amount and then the categories would be shown a sa percent of that, with the remaining shown as "Net Revenue" or something similar. Sample data set would be like this:

So, for example, with the total revenue being the 1,270,758 in this case, we would expect that in a pie chart it would show Part cost as 11.74% (149,190/1,270,758), Labor cost as 15.94% (202,546/1,270,758), and Fuel cost as 16.26% (306,622.51/1,270,758), and the remaining as 56.06% (Total of the other percentages (43.94%) subtracted from 100%.

[rohit1991]

Hi @ChrisAZ

You can achieve this by creating a simple DAX measure like this

Expense % of Revenue =
DIVIDE(
    SUM('Table'[Expenses]),
    SUM('Table'[Revenue]),
    0
)

Once you've added this measure, place Segment or Category in the pie chart's legend and the new Expense % of Revenue measure into values.

Your pie chart will look like this:

[danextian · Accepted solution]

Hi @ChrisAZ 

You can create a measure that subtracts  part, labor, etc from the total revenue as other then add all those measures to a pie or  dounut chart.

[ChrisAZ]

Thank you, this works!