Forum Discussion
Multiple data sources and ambiguous table relationships
Thank you so much! This is so helpful.
I built this all with some tweaks, but the concatenated lists in Resources[UserWithAccess] and User[AccessibleResources] are not helpful in that they are not connected tables by default and I can't find a nice way to connect them.
I'm sorry for floundering, but all of the youtube videos use calculate and countrows but they're always working with numbers in their measures (sales, salaries, hours, etc), whereas i'm trying to visualize data that isn't numerical.
I specifically need to be able to create a table in the report that shows a list of SubscriptionUsers, filtered by Resource Name, that ALSO shows users who HAVE ACCESS to the resource but don't have any EVENTS. Right now, I'm not able to show those users that have access but don't have any EVENTS (FACT table).
Am I missing something obvious? Do I just need to add all of the user info into the Subscription Users table?
THANKS AGAIN ! So much.