cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bfra4 Member
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
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?


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
4 REPLIES 4
Super User
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?


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
Community Support Team
Community Support Team

Re: Calculate the percentage individually of a rating value

@bfra4,

 


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

bfra4 Member
Member

Re: Calculate the percentage individually of a rating value

@GilbertQThanks !! resulted with 100% Stacked Bar

Super User
Super User

Re: Calculate the percentage individually of a rating value

Hi @bfra4

 

Awesome, glad you got it working!



Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"