converting measures to dimension?

Dear Members,

I have a report with a transaction listings of members across different brands.

The data is organized similar to the below table:

The end goal required, is to undertand what percentage of members spend in 1,2,3, etc brands:

I cant seem to figure a way out on power bi.

would appreciate your kind input and suggestion.

Thank you!