Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@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
Hi @Anonymous
Awesome, glad you got it working!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |