To count for specific year items

[Apple08]

Hi All

I like to count how many RAGs for a specific year, and this specifc year may varied as per user's request.  Please see the example below.  I would like to count the number of Red, Amber and Green based on the Year, e.g. 2023A, but user may also want to see 2023B or 2023C.  I wonder what is the best way to get the count?  Many thanks.

Project	Year	RAG
A	2022A, 2022C, 2023A	Red
B	2022C	Green
C	2023A, 2023B	Amber
D	2022B, 2023B, 2023C	Amber
E	2023A, 2023B	Red
F	2023B,2023C	Green
G	2023A, 2023B	Green
H	2023A, 2023B	Red
I	2023B,2023C	Amber
J	2023C	Red

[ERD]

Hi @Apple08 , can you change your table in Power Query? Basically, you need to have one year per row..