Count If based on last service date and column value

[anwilkins]

I've updated the original message to ask a more simplistic version of the question.

I need a measure that says, look at the LAST (Max) Service Date and count if the code = 0 or 2. Sample data is at the link below.

https://docs.google.com/spreadsheets/d/1ProtUa_MKCWqm5zI1Za8Yrbpxdylt5KV/edit?usp=sharing&ouid=11334...

[lbendlin]

Most likely ALLEXCEPT is the wrong tool for this.

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[anwilkins]

Agree, I changed the topic header, provided data and aked a cleaner question.

[lbendlin · Accepted solution]

something like this?

Code of last service = 
var md = max('Table'[Service Date])
return CALCULATE(COUNTROWS('Table'),'Table'[Service Date]=md,'Table'[CPT-Value] in {0,2})

[anwilkins]

Worked perfectly! I had to add the "" to the numbers but the counts are dead on! Thank you so much!