Forum Discussion

ppgandhi11's avatar
ppgandhi11
Helper V
8 years ago

DAX formula question

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.

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Hi ppgandhi11,

     

    Could you give me a sample table or some screenshots about your requirement?

     

    Regards,

    Jimmy Tao