Dax Formula calculations
Hi I need some help please. My Dax measures counts are not working dependently to one another. i have done a male and female count, but it is only taking to account either male or either female and not giving me a total count. Its as if it has taken the first value in the source whereas I want the total value. Herre are some of my Dax measures that I used: MaleCount = CALCULATE( COUNTROWS(Patients),Patients[Gender] = "Male", FILTER(ALL(Prescriptions),Prescriptions[Therapy] = MAX(Prescriptions[Therapy])), FILTER(ALL(Patients),Patients[Referring Establishment] = MAX(Patients[Referring Establishment]))) FemaleCount = CALCULATE( COUNTROWS(Patients),Patients[Gender] = "Female", FILTER(ALL(Prescriptions),Prescriptions[Therapy] = MAX(Prescriptions[Therapy])), FILTER(ALL(Patients),Patients[Referring Establishment] = MAX(Patients[Referring Establishment]))) Average Age = CALCULATE( AVERAGE(Patients[Age]), FILTER(ALL(Prescriptions),Prescriptions[Therapy] = MAX(Prescriptions[Therapy])), FILTER(ALL(Patients),Patients[Referring Establishment] = MAX(Patients[Referring Establishment]))) Registered = CALCULATE( COUNTROWS(Patients),Therapy[Created On], FILTER(ALL(Prescriptions),Prescriptions[Therapy] = MAX(Prescriptions[Therapy])), FILTER(ALL(Therapy),Therapy[NHS/Hospital] = MAX(Therapy[NHS/Hospital])), FILTER(ALL(Patients),Patients[Referring Establishment] = MAX(Patients[Referring Establishment]))) Thank you
