how to calculate percentage for the data in one column

[Tonyy]

Hello masters,

i need your support to calculate the percentage of other cost to sales cost. In below, I have cost data and sales data in one table.  

when I use measurement: 

Cost to Sales - % = Divide([Total HFM Cost],calculate([Total HFM Cost], 'HFM data'[Cost type]="Production sales")

it shows me like this :

Could someone tell me what the problem is and how to show the percentage for each row? 

Thanks!

[mhossain · Accepted solution]

Hello @Tonyy 

Try this

Cost to Sales - % =
Divide(
[Total HFM Cost],

CALCULATE(
[Total HFM Cost], 'HFM data'[Cost type]="Production sales",ALL('HFM data'Cost type (groups))
), 0
)

Hope it solves and this is what were looking for.

[Tonyy]

Thanks so much!