How to show which audits belong to a person in drill-down
(Very much learning Power BI; thank you for your patience, in advance. I always award "Solution" to solutions.) The Setup I have multiple audits belonging to each of several persons; a person, in this case, is called "Provider" I want to start with displaying a list of all of the Providers. I want to click a provider's name, and see only the audits they are the subject of. That's it, and I can't seem to get the hang of it. The Attempt I am pretty close: But, because I am using the Chart Number column, as-is, when I click the "+" sign to drill-down, I get all the chart audits, with data for the appropriate chart number populated: The Tables cr508_providerkey and ProviderRosterKey make the one-to-many relationship between the two tables. I am assuming (and have failed in my several attempts) that I need to make a measure or column out of 'Chart Number': The Goal Click the "+" sign next to the Provider's name, and see a list of chaerts where their ProviderRosterKey is listed under cr508_providerkey Sorry if this doesn't help (PowerApps example to maybe help visualize the solution I am looking for better) If I were doing this in Power Apps, it would be a nested gallery, with: - the parent gallery items property being 'Encounter Provider Roster'.'Provider Name' - and the inner gallery items property being something like Filter(Charts, ThisItem.cr508_providerkey = ProviderRosterKey, 'Chart Number') (I've been doing a lot of Power Apps lately, and now it is time to work on the reporting aspect, which brings me here.) The Very Sincere Thanks Thank you, sincerely, for your time and help. I recognize that I would not be where I am in my career without the assistance of my excellent Forum leaders andsolution-providers, and I know it.
