converting measures to dimension?

[boyscut]

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!

[ryan_mayu]

what's the expected output based on the sample data you provided?

[boyscut]

hey Ryan! thanks for following up.

This is the expected output:

Thank you.

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[boyscut]

Hello Ashish,

Thank you so much for your help.

This solution works. However, as my database is large, I noted that it takes a long time to generate the visual.

What other alternatives would you suggest?

Thank you, Ashish.

[Ashish_Mathur]

You are welcome.  I am not aware of an alternative.

[ryan_mayu]

what's the calculation logic? how many member only buy one brand? how many buy two?

[boyscut]

Hey Ryan,

Thanks for following up.

Essentially, what I am trying to understand is that from the total memberbase, what percentage of our members only purchase from 1 brand, 2 brands, 3 brands, etc.

Thank you.