Forum Discussion

ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago
Solved

Dax calculation help for %

Hi,   I am not able to get this working. I have a recordset that has following fields:   Service - field ProviderNPI - field # of Patients seen - measure (count(query[patientkey])   if Provid...
Need Help
ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago

anyone? I still need help. unable to get this done.

 

I need following report:

 

NPI                                          %of patients with prescribed service code

A                                                  23/45 * 100    (23 patients prescribed selected service code by NPI A out of 45 patients seen by NPI A)

 

:

:

 

When I select any service code from the control, it always becomes 23/23. Let me know if you want to know the formula I am using for numerator and denominator. Basically I need to ignore the service selection for denominator and I am not able to get through that.

 

Please help! 

  • ppgandhi11's avatar
    ppgandhi11
    Icon for Helper V rankHelper V
    8 years ago

    sample data provided. There is a control filter called service on this page.

     

    My problem is: when all the services are selected, column B and C both shows 45 for NPI A.  When I select any service, both the B and C would change it to 23 (assuming that for selected service 23 patients were prescribed that service).

     

    Formula I am trying to use for numerator:

    # of Patients = calculate(DISTINCTCOUNT(BaseQuery[ptkey]))

     

    for denominator:

    not working, I am trying different functions.  Denominator is the problem in my case. So the % always becomes 100.

     

    Thanks!