Calculate the percentage individually of a rating value

[Anonymous]

Hi,

I have a table with preference values on the part of consumers. 
I have a [ColorJarvalue] and [ColorJar_des] field:
(ColorJarvalue)1 = much too light (ColorJar_des) , 2 = too light, 3 = Just About Right, 4 = Too Dark, 5 = Much too dark, and i got some results.

And I wanted the following chart (for example):

I want to isolate by brand, the values ​​collected by percentage (100%).

I tried this:

DIVIDE(COUNTA('consumer'[ColorJar]), CACULATE(SUM('consumer'[ColorJar]), ALLEXCEPT(brands,brands[Brand])),0)

Best regards. 

[v-yuta-msft]

@Anonymous,

---

I have a table with preference values on the part of consumers. 
I have a [ColorJarvalue] and [ColorJar_des] field:
(ColorJarvalue)1 = much too light (ColorJar_des) , 2 = too light, 3 = Just About Right, 4 = Too Dark, 5 = Much too dark, and i got some results.

---

Which kind if value in field [ColorJarvalue] and [ColorJar_des]? Could you share some sample data and clarify more details about your requirement?

Regards,

Jimmy Tao

[GilbertQ · Accepted solution]

Hi there

Does the 100% Stacked Bar chart visual not work?

You could have the measure and have the Brands on the Axis and Colors on the Legend?

[Anonymous]

@GilbertQThanks !! resulted with 100% Stacked Bar

[GilbertQ]

Hi @Anonymous

Awesome, glad you got it working!