Calculation of percentages while analyzing survey results with multi-choice questions

[Anonymous]

Hello,

Can anyone support with calculation of percentages while analyzing survey results with multi-choice questions, please?

Data table is structured like below, simplified example (I know this structure is not very good, but restructuring is problematic):

Indicator	Main_Breakdown	Breakdown_Type	Breakdown	Value
Indicator1	Main	Main		10
Indicator1	Breakdown	Sex	Female	6
Indicator1	Breakdown	Sex	Male	4
Indicator1	Breakdown	Fruit preferred	Apple	3
Indicator1	Breakdown	Fruit preferred	Pear	7
Indicator1	Breakdown	Fruit preferred	Banana	4
Indicator1	Breakdown	Fruit preferred	Peach	8
Indicator2	Main	Main		15

As you see, some indicators are disaggregated, some of those disaggregations are multi-choice i.e. sum of categories (fruit preference in the example above) is higher than total (sum of fruit preference is 22 , while total is 10).

How do I write a measure to deal with calculation of percent for such categories?

So that I can have at the end:

Apple	30%
Banana	40%
Pear	70%
Peach	80%

Thanks!