Forum Discussion
mdalton
Helper I
Helper INew Column-Output Default Branch by Max(CountofPatient) by Zip
I have a table with : I want a new column for a Default Branch that will recognize that those top three zipcodes are the same, and will output the branch with the highest patient count per ...
I figured it out. I was pulling more values than I thought
mdaltonHelper I
Helper II tried:
Column=CALCULATE(MAX(Table[CountofPatient]), ALLEXCEPT(Table, Table[Zip]))
But it gave me:
Which does not make sense. I figured I could go from here and add another column where if the count of patients is the same as column, give me branch.
- mdalton
I figured it out. I was pulling more values than I thought