How to combine multiple pairs of columns into a single pair

[salmanaslam]

Hi everyone,

My data it looks like that;

ID     Date     Name     Brand 1     Brand 2     Brand 3     Brand 4     Brand 5

1      23/4        A           Jazz          Candy        Warid      Jan Food      Warid

2       8/3         B          Khaadi        Jazz          Jazz               -              Khaadi

3     10/8         C         Bonanza   Bonanza     Foodie           -              Jazz

Now my query is that, how to show % at all brands into a single graph.

They are not showing in single graph when i draw them.

Kinldy tell me what can i do for this.

[v-juanli-msft]

Hi @salmanaslam 

Could you show an exmaple of what the result "% at all brands into a single graph" should be?

I make a test as below:

Unpivot columns(from "Brand 1" to "Brand 5") in Edit queries

"apply&&close"

create measures

Measure = CALCULATE(DISTINCTCOUNT(Table1[Attribute]),ALL(Table1))

Measure 2 = CALCULATE(COUNT(Table1[Attribute]),FILTER(ALLEXCEPT(Table1,Table1[Name]),Table1[Value]<>BLANK()))

Measure 3 = [Measure 2]/[Measure]

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[salmanaslam]

Thanks for replying me.

But i want to to show brand wise percentage not name wise.

Graph should be like this;

[salmanaslam]

Please guide me,

Anyone there?????