Hi, This is little complicated to explain and I am not able to attach/upload PBIX file so I will try to explain.
I have a query that brings provider specific information on page1. There is a control filter called service on top. On bottom it shows the providers by bar chart. The 2nd page is provider specific information having drill through based on provider.
When I go from 1st page to 2nd page with provider specific information and for a given service I can see all the provider info the way I want. Up to this all is fine.
2nd page displays: Provider, # of patients seen for given service, # of patients seen for all services.
What I want now is:
For a given service, I want to list all the providers in matrix form on 2nd page. How would i get this done? I can create a measure that allows me to count number of providers associated with this service and then prints it in the card visual. But that is the total # of providers for this service only. I want to get the details of these providers.
Please let me know if you need more clarification. Thanks.
