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
MEHUL123
Frequent Visitor

Conditional distinct count dax

Hi,

 

Request your help to create DAX for Distinct count of IDs against each Name rows in table.

(desired result shown in last colunms)

 

NameID NO.DAX for Desired Result
(Distinct ID against Name)
RohanAA2
RohanBB2
RohanAA2
MiraBB2
JohnAA1
MiraCC2
CelvinAA1
JamesAA1
CelvinAA1

 

Thanks in advance..

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@MEHUL123 Try this. PBIX is attached below signature.

Distinct Count = 
    VAR __Name = MAX( 'Table'[Name] )
    VAR __Table = FILTER( ALLSELECTED( 'Table' ), 'Table'[Name] = __Name )
    VAR __Group = SUMMARIZE( __Table, [Name], [ID] )
    VAR __Result = COUNTROWS( __Group )
RETURN
    __Result


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Kedar_Pande
Super User
Super User

@MEHUL123 

DAX measure:

Distinct ID Count = 
CALCULATE(
DISTINCTCOUNT(Table[ID NO.]),
ALLEXCEPT(Table, Table[Name])
)

This will give you the distinct count of ID NO. for each Name.

 

 

If this helped, a Kudos 👍 or Solution mark would be great!🎉
Cheers,
Kedar Pande
Connect on LinkedIn

Greg_Deckler
Community Champion
Community Champion

@MEHUL123 Try this. PBIX is attached below signature.

Distinct Count = 
    VAR __Name = MAX( 'Table'[Name] )
    VAR __Table = FILTER( ALLSELECTED( 'Table' ), 'Table'[Name] = __Name )
    VAR __Group = SUMMARIZE( __Table, [Name], [ID] )
    VAR __Result = COUNTROWS( __Group )
RETURN
    __Result


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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.