Measure to get distinct countries from column holding a list of countries for each row

[Anonymous]

Hi,
Could someone help with the below scenario:
I have a table similar to below which holds a list of countries for each row:

ID	Group	Country
1011	A	INDIA;CHINA
1038	A	INDIA;CHINA;ENGLAND;SRILANKA
5052	B	SWEDEN;FINLAND
3033	C	SRILANKA
9800	B	SWEDEN;NORWAY
6500	B	NORWAY;FINLAND

Now I need to create a measure that gives me the distinct country based on the filters applied for 'ID' or 'Group' columns.

For example, if i apply the filter "Group = B", it should consider the 3 rows for group B and measure should give me the distinct  count as 3. It will get the 3 distinct countries from the combination of those 3 rows (SWEDEN,NORWAY,FINLAND)

Could you please help me here.
In the real scenario the list is much longer.

[Rupak_bi]

Hi , Please see below

if you are looking for this then follow @Anonymous answer.

[Rupak_bi]

Is this something you are looking for?

[Anonymous]

Thanks.
But I want to get the distinct count of the countries from the column 'Country' for the selected filters.
It has to be "3" when Group B is selected (SWEDEN,NORWAY,FINLAND) ,
"4"  for Group A (INDIA, CHINA, ENGLAND, SRILANKA)
and "1" for Group C (Only SRILANKA).

[Anonymous · Accepted solution]

Hi,

Below are the results as expected..

Firstly ., Need to Split the country column with a delimiter in power query editor.

Then create a measure..