Categories percentage based of different column total

[jammy123]

Hello Power BI group,

This is my first post and question. I am looking to create a new measure which gives me the summary of categorized rows but will be as a percentage of a different column total. I have given an example shown below.

First 3 columns are already listed (date,code,cost). I have to create a new column/measure where I can express the cost of code in % of price total which is from a different column. Also summarize the code and create column giving the % of price total. Please help!

[v-jiascu-msft · Accepted solution]

Hi @jammy123,

If they are from one table, it could be like below.

Measure =
DIVIDE (
    SUM ( Table1[cost] ),
    CALCULATE ( SUM ( Table1[Price] ), ALL ( Table1 ) )
)

If they are from two tables, it could be different.

Measure =
DIVIDE ( SUM ( Table1[cost] ), SUM ( PriceTable[Price] ) )

Best Regards,

Dale

[jammy123]

Measure =
DIVIDE (
    SUM ( Table1[cost] ),
    CALCULATE ( SUM ( Table1[Price] ), ALL ( Table1[code] ) )
)

 This worked for me. Thanks for your help @v-jiascu-msft

[jammy123]

Also, looking at creating a responsive graph based on the date input or period where the code % of total price changes

[jammy123]

can someone help please?