Forum Discussion
Matrix Rows - Related table showing all values, rather than just the related one
Explicit measures require a filter context. You are trying to report on things that aren't there (gaps in your data). That requires cross joins and / or disconnected tables. You can also use COALESCE to handle some situations.
unavailable/month = COALESCE(DISTINCTCOUNT(Availability[date]), 0)see attached.
Explicit measures require a filter context. You are trying to report on things that aren't there (gaps in your data). That requires cross joins and / or disconnected tables. You can also use COALESCE to handle some situations.
unavailable/month = COALESCE(DISTINCTCOUNT(Availability[date]), 0)
see attached.
Thanks again for the reply and the additional context of what is going on here.
What I ended up doing, which gives me the result I want, is to create an additional column (ownerEmail) on my "Homes" table, which uses a merged query to pull in the email address of the owner from the users table.
The part that is still confusing to me, is given the relationship I set up between Homes[ownerId] and Users[userId], why isn't the visual recognizing the related email field from the user table when the prior row is ownerId and displaying just the related email? Is this specific to the way a matrix works in particular? Is there a term I could search for in order to read up about this for a more in-depth explanation of why the extra column on the Homes table is necessary to get this to work the way I want it to?
search for "auto exist"