ignore column value filter in a table visual

hello

i have visual table with below fields'

I'm trying to calculate the agent achievement which is made of

1- core achievement measue (which equals 90%* by new achiev% measure)

2- accessories achievement (which equals 10%* new achiev% measure)

3- total achievement (equals the sum of core achievement and accessories achievement)

as you can see from the table above, i managed to to calculate the first 2 parts for core achievment and accessories achievement. the problem is when i was trying to sum the two percentages it's not working. as for [category type]= 'accessories' it will show blank in core achievment measure and for [category type]='Core' it shows blank for accessories achievement.

i want to show the accessoreis achievemt '7%' instead of blank for category type ='core' so that for each core category i can sum both core and accessories achievement as below