can not get the correct value using countrows(filter( ))

Hi Anonymous 

Thanks for reaching out to us.

please try this measure,

Number = countrows(filter('Table', 'Table'[type]="sold"))

if you want to put it into table visual, please  try this measure,

Measure = countrows(filter(ALL('Table'), 'Table'[type]="sold"))

If you are interested in the difference between the two, you can read the context

Context in DAX Formulas (microsoft.com)

Solved: contexts in power bi - Microsoft Power BI Community

Row Context and Filter Context in DAX - SQLBI

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.