Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have this,
Labor |
Ara |
Ara;Kiano |
Ara |
Kiano |
Kiano;Edi Wan;Fahri Hamid |
I want to get this column in Power BI:
Labor | Count |
Ara | 1 |
Ara;Kiano | 2 |
Ara | 1 |
Kiano | 1 |
Kiano;Edi Wan;Fahri Hamid | 3 |
How to do it? Thank you
Solved! Go to Solution.
pls try in DAX
pls try this
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |