- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 returns blank.
The query looks like this:
And the formula ('leeg' means blank or empty):
I have the same issues with other tables in my file. Some work, some don't. What could be a solution to this?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @amitchandak , you can see a picture of the table in the first post. It does contain data, so we can rule that one out already.
I also found the trigger for not giving a value, but no work around yet. It is caused by one of the active relationships for this table. If I delete one of the highlighted relationships, the formula works as it should. I do need a relationship though, and it has to be on the currently selected column. I can't change the crossfilter direction of the relationship, this triggers an error. Any idea how to solve that?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Silvermountain , Strange, Hope the table you are giving is having data
Can you share a sample pbix after removing sensitive data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 🙂

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-14-2024 05:50 AM | |||
05-28-2024 12:47 PM | |||
09-11-2024 09:50 PM | |||
10-21-2024 04:12 AM | |||
11-30-2023 05:32 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |