Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 zipcode like such:
Solved! Go to Solution.
I figured it out. I was pulling more values than I thought
I 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.
I figured it out. I was pulling more values than I thought
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |