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 Power Bi Community. I am new and excited to be learning this amazing software.
Question: I have a column like below:
AECOsim
0
0
0
1
3
0
4
2
3
4
2
1
1
I want to be able to pull how many occurences happen with each value, like this:
0 = 4
1 = 3
2 = 2
3 = 2
4 = 2
and so on. I have about 30 of these types of columns to do this to. Any and all help is appreciated!
Thank you
Solved! Go to Solution.
Hi @CHBIV,
I have created a sample table based on your example and I have created a measure COUNT(Table1[AECOsim]).
Plot this on matrix, it gives exactly the same output which you required.
I hope it helps you. If yes please accept it as solution.
Cheers,
Anupam
With us new people (comment in general) it would be nice to show screen shots of workflow, or link to video showing process. I am a very visually driven fellow, and just seeing this code, I am not sure what to or how to apply it.
Thank You!
Thank you ever so much!!! exactly what i am looking for!!!!
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |