Percent of Column Total

[Anonymous_]

Hi,

I want to create a calculated measure for calculating cost percentage per supplier. I'm not able to get the exact formula that would give me column percentages:

I need a formula, specifically a calculated measure to perform the activity of column 'C' in the above picture. 

Thanks for the help!:)

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new measure.

Expected result measure: =
VAR _qty =
    SUM ( Data[Qty] )
VAR _qtyall =
    CALCULATE ( SUM ( Data[Qty] ), ALL ( Data[Product] ) )
RETURN
    DIVIDE ( _qty, _qtyall )