DAX Help: Unique count by row

[_Alex_]

Suppose I have a dataset as follows:

Car_ID    Owner_Name  Number_of_Owners

1             Adam               3

1             Bob                  3

1             Carrie               3

2             Alex                 2

2             Bill                   2

3             Aron                1

What DAX expression would produce the column "Number_of_Owners" above?

Thank you!

[Greg_Deckler · Accepted solution]

As a column:

Number of Owners = 
VAR __table = FILTER(ALL('Table',[Car_ID]=EARLIER([Car_ID]))
RETURN COUNTROWS(__table)

[_Alex_]

Greg_Deckler,

Thanks for your response!

A few questions:

1. When using the code you provided I'm getting an error which states "Too few arguments were pased to the FILTER function".  As such, I'm assuming that there should be a right-parenthesis after 'Table'.

Number of Owners = 
VAR __table = FILTER(ALL('Table',[Car_ID])=EARLIER([Car_ID]))
RETURN COUNTROWS(__table)

2.  After adding the right-parenthesis after [Car_ID] I'm now getting an error which states "EARLIER/EARLIEST refers to a nearlier row context which does not exist".

Thank you!

*Edit:

Nevermind; it looks like the EARLIER statement doesn't produce this error when I create a column instead of a measure.

[Greg_Deckler]

Awesome. If you want it as a measure, that would be:

Measure 4 = 
VAR __carid = MAX([Car_ID])
VAR __table = FILTER(ALL(Table5),[Car_ID]=__carid)
RETURN COUNTROWS(__table)

[PattemManohar]

Could you please try this..

TotalOwners = CALCULATE(COUNT(CarOwners[CarID]),FILTER(ALL(CarOwners),CarOwners[CarID] = EARLIER([CarID])))