Forum Discussion
can not get the correct value using countrows(filter( ))
Hello!
I used Number=countrows(filter(table1, event="sold"), I got a blank value.
However if I create a new table firstly Newtable=filter(table1, event="sold"), and then Number=countrows(Newtable), it works and gets the correct number. I can not understand this! could someone help me! Thanks!
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.
2 Replies
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.