cancel
Showing results for
Did you mean:
Highlighted
Member

## Calculate the percentage individually of a rating value

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Calculate the percentage individually of a rating value

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?

"Proud to be a Datanaut!"
4 REPLIES 4
Super User

## Re: Calculate the percentage individually of a rating value

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?

"Proud to be a Datanaut!"
Community Support Team

## Re: Calculate the percentage individually of a rating value

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

Member

## Re: Calculate the percentage individually of a rating value

@GilbertQThanks !! resulted with 100% Stacked Bar

Super User

## Re: Calculate the percentage individually of a rating value

Hi @bfra4

Awesome, glad you got it working!