Filtering a table for Max and Min

Hi naninamu 

If you want to display the minimum and maximum scores when your visualization only includes the Folder field, you can simply use the Score column twice—once with the Min aggregation and once with the Max aggregation, like in the example below.

However, if you need to use these measures alongside other dimensions or within another measure, you need to adjust the filter context. You can do this using the ALLEXCEPT function, ensuring that the Min and Max calculations remain specific to each Folder.

Here’s how you can define the measures:

Folder_min = CALCULATE(min('Table'[Score]),ALLEXCEPT('Table','Table'[Folder]))

Folder_Max = CALCULATE(max('Table'[Score]),ALLEXCEPT('Table','Table'[Folder]))

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.