Count members based on Measure result

TheoC Hello! I have the same issue but in a different scenario and I've tried to steal the solution you have created for Aruljoy but it's not working for me so I'm clearly missing something - please could you help?!

I have a table with date of update, project reference number and current RAG status - this pulls into my report as "RAG Outcome" column and contains either "RED", "AMBER" or "GREEN".  

In order to build a measure to return whatever the most recent RAG is for any given project - so only one result per project but that result could be March's update, or June's update etc etc.  So to do that I used LASTNONBLANKVALUE, which needed a measure, not a column value so have ended up with...

Then I have the measure which gives me the latest RAGs only - which works for me

And have another measure to convert those names into RAG colour numbers for easier conditional formatting of other tables..

I tried to play around with your solution above but it's not giving me what I need...

I'm after three separate measures which just count how many GREEN/AMBER/RED rags there are in the latest RAG values measure/output.  All my attempts have either added up all of them regardless of date/being most recent or not done anything. I'd be so grateful if you could make sense of this for me - I've spent hours on it already and going stir crazy 🙂

Thank you

- Lauren