Calculate Percentage using only one column which has all values

[WaleedAli]

Hi,
Hope you all are doing well
I have a column which includes total revenue and all the other fields e.g total project cost, project indirect cost and others these all are in one column as shown in image below. How can i calculate percentage of all the fields in that column out of total revenue which is also in that column as you can see in image.
alittle help required! Thanks in advance.

[Ashish_Mathur]

Hi,

Does this measure work?

Measure = sum(Data[Total])

Measure 2 = divide([Measure],calculate([Measure],Data[Expense]="Revenue"))

Format Measure 2 as a %.

[danextian]

Hi @WaleedAli 

Try this:

percent =
DIVIDE (
    SUM ( Table[Value] ),
    CALCULATE (
        SUM ( Table[Value] ),
        FILTER ( ALL ( Table[Expense] ), Table[Expense] = "Total Revenue" )
    )//to divide the sum for each item in Expense over Total Revenue
)

[WaleedAli]

@danextian Hi, i appreciate your effort.
But it is still not working.
I have carried out total revenue value from column. But when i put that value in DIVIDE function it don't print out all the percentages of the remain field out of total revenue. Alittle help needed thanks.

[danextian]

Hi @WaleedAli ,

What do you mean by the percentages of the remain field out of total revenue?

Also please share a sample data that we can easily manipulate - not an image.