Create measure to get distinct value

[krishak77]

Hello All,

Kindly need help on the below situation.

I have a duplicate numbers in Table1 and i need to create measure for Distinct value.

I am using this in measure 

SOTAT_FR_Distinct = DISTINCT('SOTAT Analysis'[Sotat])

But it is not working

Thanks you in advance

Regards,

AK

[ChandrashekaraD]

Check your table relationship is it one to many OR many to many, the mapping column should not be a duplicate value s

[krishak77]

Hello Dangar,

Thanks for your response.

I need the value of Distinct

Eg

Table1

0

0

0

1

1

1

3

3

3

I need as 

0

1

3

[Dangar332]

hi, @krishak77 

 i suggest you to make new table using

distinctcount = 

 SUMMARIZE(SOTAT Analysis,'SOTAT Analysis'[Sotat])

which look like 

and now you can make table visual or any visuals like these 

and yah, don't forgot to change to check below 

here i am use different value so don't confuse

Did i answer your question? Mark my post as a solution which help other people to find  fast and easily.

[krishak77]

Hello Dangar,

Actually i have did the same thing, but i have some categories in another table and when i do filter results are not getting change.

Even though i link the relation for both the table.

[Dangar332]

hi, @krishak77 

 are you want to count of distinct or what?