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:
Go to Solution.
I figured it out. I was pulling more values than I thought
View solution in original post
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.
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.