How to get percentage of a group for multiple columns

[jonalyncas]

Hi! I need your expert guidance, please. I am working on a dataset to get the volume percentage of each size, per quartile. I also want to create a table visual in powerBI. Here is what the data and expected output looks like.

Thank you in advance! ❤️

PS:
I've used the below formula but im getting the same % results for all sizes for Q1-Q4 . 😞

Test Engage = DIVIDE(COUNT('Table Q1),

CALCULATE(COUNT('TTable Q1]),

ALL()))

[jonalyncas]

Hey @Anonymous , thank you so much. First time I leaned about unpivot. Very helpful. And thank you for helping out with the steps. You're a Gem. 🙂

[Anonymous · Accepted solution]

Hi @jonalyncas 

Step 1: Please go to Power Query and Unpivot all your data

Step 2: Go back to your reporting tab and create a matrix as per such

Step 3: Click on dropdown on count of value > Show Value As > Percent of Row Total

BR