I am trying to define a parametric report using program data. In my Power BI model, this is easily resolved using relationships between the tables, and I am trying to recreate that same amount of filtering logic in the Paginated Report Builder. Essentially, I am trying to create a dropdown that filters a list of our programs, returns a dataset of our services rendered by those programs, and then a dataset of the clients served by those programs. I need to know the services, because that is how I am planning on filtering the list of clients.
I have a number of parameters that are used to identify one or more programs we run, and those parameters filter the dataset of all of our services delivered. Inside that filtered dataset, includes a field containing all of the client GUID's. I want to use that list of GUID's to filter for a second dataset of our client list, so I can then report on the clients that we served in those programs.
I have tried to use a separate set of parameters, but receive warnings that the parameters are always blank, and I have tried to filter the dataset using an aggregate function, but that is not permitted.
Is there any way to filter one dataset based on the values of another? I am surprised that this is not more standard functionality.
