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.
Hello!
I am working with data like this where I have a user and they are "rating" 5 items:
I would like to find the frequency of how many times each rating comes up under each item. Something that looks like this, where the blank cells would the the count or frequency how many times that rating comes up in the entire table:
Thanks so much in advance!
Solved! Go to Solution.
Hi @Anonymous ,
Firstly, we need to unpovit this table like below:
Then we can create a table like below, this table is used for displaying the column name, then we need to create relationship between the column 2 and Value of above unpovited table.
After that, we can drag the Column 1 as column name, Attribute as the row name and value as the value, we need to set the value as count:
Best Regards,
Teige
Hi @Anonymous ,
Firstly, we need to unpovit this table like below:
Then we can create a table like below, this table is used for displaying the column name, then we need to create relationship between the column 2 and Value of above unpovited table.
After that, we can drag the Column 1 as column name, Attribute as the row name and value as the value, we need to set the value as count:
Best Regards,
Teige
@TeigeGao THANK YOU SO MUCH. Your reply was so well thought out and informative. I tried it and it worked!
Thanks again. 🙂
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |