need help with DAX in power bi from excel

[datadavebi]

please help - I have reproduced this in excel -

Created a pivot, filtered on status (1-10, but I just want id which has been in status 1/2/3/4), rows are ids and the value is the count of status, which is the required answer.

I am aware that by using the matrix as a viz you can replicate the same but I have to build some another viz and I am unable to figure the DAX for this.

Any articles, anything will help here.

For example, an id has been in status (1,2,3) - the count of status will be 3...

an id has been in status (1,2) - the count of status will be 2

[Rayshin · Accepted solution]

Should be something like this.

YourMeasure =
CALCULATE(
COUNTROWS(YourTable)
,FILTER(
ALLEXCEPT(YourTable,YourIDColumn)
,YourTable[YourStatusColumn] in {1,2,3,4}
)
)

[datadavebi]

I spent like hours on this yesterday.. thanks a ton gentleman.