Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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})
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
Agree, I changed the topic header, provided data and aked a cleaner question.
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})
Worked perfectly! I had to add the "" to the numbers but the counts are dead on! Thank you so much!
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |