How to get different combinations count?

[akshaynangare]

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

[Greg_Deckler]

So typically you would split that out in Power Query and unpivot.

[akshaynangare]

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)

[v-cherch-msft]

Hi @akshaynangare

You may refer to below dax to create a calculated column.

Regards,

Cherie