Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a SharePoint "Country" Dropdown multiselect column, Country column values are
A
B
C
D
E
F
G
The user can select multiple values the record values like below
1) A,B,C
2)A,C,B,D,F
3)A,B,C,D,E,G
4)A,B,C
I want to take the different combination and their their count
So we have A,B,C combination occure 2 times: Count is 2
So typically you would split that out in Power Query and unpivot.
No, I don't want to split,
I Just wanted to get the count of Unique combination.
In each record which combination user has selected and the count of that combinationpresent in List (Table)
You may refer to below dax to create a calculated column.
Regards,
Cherie
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |