User Profile
BIBen
Helper I
Joined 5 years ago
User Widgets
Contributions
Re: How to show which audits belong to a person in drill-down
I tried switching the arrows to be unidirectional, but that did not solve the issue. Being new (and probably naive), I liked the two-directional arrows so that options not allowed in the visuals do not appear in the slicers, like when I click an officve, onthe the employees who work at that offive appear in the slicers, ans such. If you wouldn't mind looking over my schema, I include it below. To assit with parsing what is going on, in the below screen shot, I framed 3 structures that are generated dynamically from the structure in the upper left corner; these are the 3 roles involved in the process, requiring (I uderstand) their own tables. I realize that there is a ton of nuance in schema design, but, if you have the time, please, help me pinpoint the issue, I would be greatly appreciative of your help. I can supply whatever other collateral data you may need, and answer whatever questions you may have, to help further this solution. Thank you, Ibendlin.Re: How to show which audits belong to a person in drill-down
I am going to look into everything you said and try to make i twork from my end. It may be obvious to you, but I learned Power BI and relational tables for this report, and very much appreciate you help. When it works, I'll award Solution, I promise. Thank you, Ibendlin.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.Re: How To Use LOOKUPVALUE
selimovd Yeah, I actually tried that, burt reverted the form back to what the docs has. removing ambiguity produces this: Again, cra15_providerkey is in cra15_ccadchart: There is a One:Many relation**bleep** between RosterKey and ProviderKey but I haven't been able to get RELATED() to work, either:
