_Alex_ Tracker

DAX Help: Unique count by row II

_Alex_ — Wed, 26 Sep 2018 16:51:30 GMT

Suppose I have a dataset as follows:

Car_ID Owner_Name Car_Owner_State Unique_State_Count

1 Adam FL 2

1 Bob FL 2

1 Carrie GA 2

2 Alex NC 1

2 Bill NC 1

3 Aron IL 1

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

Thank you!

Re: DAX Help: Unique count by row

_Alex_ — Wed, 26 Sep 2018 16:34:43 GMT

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.

DAX Help: Unique count by row

_Alex_ — Wed, 26 Sep 2018 15:46:58 GMT

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!