Forum Discussion
COUNTROWS(RELATEDTABLE
Hi Elin! 😊
It sounds like you're trying to use the `COUNTROWS` function with the `RELATEDTABLE` function to count the number of stakeholders per apartment. If it's not working for all apartments, there could be a few reasons why this is happening.
One possibility is that there may be some issue with the relationship between the two tables. You could check if the relationship is set up correctly and that it's active. Another possibility is that there may be some issue with the data in one or both of the tables, such as missing or incorrect values.
If you're still having trouble, you could try using a different approach to count the number of stakeholders per apartment. For example, you could use a `CALCULATE` function with a `FILTER` function to count the number of rows in the "Interest" table that are related to each apartment in the "Apartment" table.
I hope this helps! Let me know if you have any further questions. 😊
Resolver IIHi Elin! 😊
It sounds like you're trying to use the `COUNTROWS` function with the `RELATEDTABLE` function to count the number of stakeholders per apartment. If it's not working for all apartments, there could be a few reasons why this is happening.
One possibility is that there may be some issue with the relationship between the two tables. You could check if the relationship is set up correctly and that it's active. Another possibility is that there may be some issue with the data in one or both of the tables, such as missing or incorrect values.
If you're still having trouble, you could try using a different approach to count the number of stakeholders per apartment. For example, you could use a `CALCULATE` function with a `FILTER` function to count the number of rows in the "Interest" table that are related to each apartment in the "Apartment" table.
I hope this helps! Let me know if you have any further questions. 😊