Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
I´m having issues with the following topic.
I have products that are related to different clients, and they have opinions about them.
Example:
PRODUCTO | CLIENTE | OPINION |
A | 1 | GOOD |
A | 2 | GOOD |
A | 3 | BAD |
B | 4 | GREAT |
B | 5 | GREAT |
B | 6 | GOOD |
C | 7 | LAME |
C | 8 | PERFECT |
C | 9 | PERFECT |
How can I extract which opinion @repeats the most in each product in a dashboard im doing??
Thanks in advance!
Solved! Go to Solution.
Hi @Gustavo91Peru ,
My previous measure is wrong, it's calculating based on alphabetical values.
I tried a new one and handling ties:
Hi @Gustavo91Peru ,
My previous measure is wrong, it's calculating based on alphabetical values.
I tried a new one and handling ties:
You can use this code to create a measure:
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |