DAX measure Help

[johndolan2]

Hi. Any help would be appreciated. I am trying to get the total count of service IDs. A service ID has 2 end points. One end point at one street address and the other at a 2nd street address. What I am trying to get to is shown in the bottom table.

My starting point is the table below

street address	service ID	city	state
1 STATE ST	ABC123	BOSTON	MASSACHUSETTS
15 JOY ST	ABC123	SPRINGFIELD	MASSACHUSETTS
8 APPLE AVE	DEF123	TACOMA	WASHINGTON
1 STATE ST	DEF123	BOSTON	MASSACHUSETTS

What I am trying to get --

State	Service ID Count
MASSACHUSETTS	3
WASHINGTON	1

Thanks,

John

[amitchandak · Accepted solution]

@johndolan2 , In a visual with count(Table[service ID])  with state should give same result

[amitchandak · Accepted solution]

@johndolan2 , In a visual with count(Table[service ID])  with state should give same result

[johndolan2 · Accepted solution]

Hi Amit!! Oh Thank you!!!!!!!!

John