Count rows based on another column in Matrix for each Listed Project

[monsnap1]

Hi folks.

This has been bugging me for a while - Is it possible to count up rows with a certain 'state' and add it as a new column for each project as per the image below?

Many thanks

[marcelsmaglhaes]

Hey @monsnap1 !
You should write a measure something like bellow.

If this post helps, please mark as solved.

Regards,
Marcel

to_do = CALCULATE(COUNT('Table'[State]), ALLSELECTED('Table'[Task]),'Table'[State] = "To Do")

done = CALCULATE(COUNT('Table'[State]), ALLSELECTED('Table'[Task]),'Table'[State] = "Done")