Forum Discussion
Post ProdigyCouldn't load the data for this visual error
The error message is telling you that you're trying to return a tabl, which isn't allowed (even if the table only has one row and column). The docs for the summarize page says that the return value is a table: https://learn.microsoft.com/en-us/dax/summarize-function-dax
DAX measures only allow you to return a single value.To fix this, you need to aggregate your CustomerIDs table - so something like:
// ... your code here RETURN COUNTROWS(CustomerIDs)might be what you're after.
Super UserThe error message is telling you that you're trying to return a tabl, which isn't allowed (even if the table only has one row and column). The docs for the summarize page says that the return value is a table: https://learn.microsoft.com/en-us/dax/summarize-function-dax
DAX measures only allow you to return a single value.
To fix this, you need to aggregate your CustomerIDs table - so something like:
// ... your code here
RETURN
COUNTROWS(CustomerIDs)might be what you're after.