Get the Min and Max values for the entire column

[powerbiguy_]

I have the following tables:

What I want to achieve is to get the Min and Max values of the entire sales column by branch. I already tried using calculated columns but I have performance issues since I am dealing with a million records.

[v-yalanwu-msft · Accepted solution]

Hi @powerbiguy_  ,

According to your description, you could create two measure (max and min ), the following formula to create a measure:

Min = CALCULATE(MIN('Income'[Sales]),ALLEXCEPT('Brancher',Brancher[Id]))

Max = CALCULATE(MAX('Income'[Sales]),ALLEXCEPT('Brancher',Brancher[Id]))

The final output is shown below:

Best Regards,
Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @powerbiguy_ ,

are the two tables connected with a relationship?

If yes, then just add the following measure to a table with the branches:

Min Sales = MIN(Income[Sales])

For Max the same with the MAX function.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[powerbiguy_]

Yes, but I failed to mention above that I have a slicer for the year and it affects the result.