Forum Discussion
Solved
Countrows gives no value
Hello! I want to count the number of rows in a table. My PBI file contains multiple tables. In one table, I can use the DAX expression countrows and get the correct result, in another it always r...
Have been looking into it for the last hour or so, and found the solution. Had to be in a relationship, so I tested all of them. There was a relationship to another table, with a few tables in between. This last table was empty and caused an issue for the table that wasn't empty.
Thanks for your replies 🙂
Silvermountain , Strange, Hope the table you are giving is having data
Can you share a sample pbix after removing sensitive data?
Have been looking into it for the last hour or so, and found the solution. Had to be in a relationship, so I tested all of them. There was a relationship to another table, with a few tables in between. This last table was empty and caused an issue for the table that wasn't empty.
Thanks for your replies 🙂