Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
krishak77
Helper I
Helper I

Create measure to get distinct value

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
5 REPLIES 5
ChandrashekaraD
Frequent Visitor

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

krishak77
Helper I
Helper I

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

hi, @krishak77 

 i suggest you to make new table using

distinctcount = 

 SUMMARIZE(SOTAT Analysis,'SOTAT Analysis'[Sotat])
which look like 
Dangar332_0-1696073321697.png

 

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

Dangar332_3-1696073661047.png

 


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

Dangar332_2-1696073472273.png

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.

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
Super User
Super User

hi, @krishak77 

 are you want to count of distinct or what?

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.