Forum Discussion
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...
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.
Could you provide a few rows of sample/dummy data?