Count occurrence

[qwerttty]

Hi, I'm trying to calculate the amount of open and closed count in the matrix. 

I'm using the measure below, however it gives me the sum of open and closed in the column, are there any ways to solved it to make the value same as the card 

Count = SUMX(VALUES(Sheet1[Type]),CALCULATE(COUNT(Sheet1[Status]),ALLSELECTED(Sheet1[Status])))

Eg. For the canteen, the closed should be 2 and open should be 3 in the matrix and the total should be 5. 

Thanks so much for the help. 

[wdx223_Daniel · Accepted solution]

Count = SUMX(VALUES(Sheet1[Type]),CALCULATE(COUNT(Sheet1[Status]),Sheet1[Status] IN VALUES(Sheet1[Status])))