Forum Discussion
Dax calculation help for %
I found the solution.
below link helped (Thanks @greg_deckler for answering it there)
https://community.powerbi.com/t5/Desktop/Make-measure-ignore-specific-filter/td-p/336870
I used the denominator value as:
# of Total Patients = CALCULATE(DISTINCTCOUNT(BaseQuery[ptkey]), all(BaseQuery[Service]))
This ignores the Service filter and gives the desired value! Thanks Aron_Moore for looking into this.
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!
I found the solution.
below link helped (Thanks @greg_deckler for answering it there)
https://community.powerbi.com/t5/Desktop/Make-measure-ignore-specific-filter/td-p/336870
I used the denominator value as:
# of Total Patients = CALCULATE(DISTINCTCOUNT(BaseQuery[ptkey]), all(BaseQuery[Service]))
This ignores the Service filter and gives the desired value! Thanks Aron_Moore for looking into this.