Need help od DAX Minimum and maximum function

Hi Anonymous ,

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

Create two measures

MaxLogins = 
CALCULATE(
    MAX('Table'[Value]),
    FILTER(
        'Table',
        'Table'[Column] <> "User"
    )
)

MinLogins = 
CALCULATE(
    MIN('Table'[Value]),
    ALLEXCEPT('Table', 'Table'[City])
)

Final output

However, this is based on the data I created. In fact matrix is based on the original table adding two columns behind it is not generating it. If this method doesn't work for your file, please provide your pbix file including your table to table relationships, tables, and hide sensitive information ahead of time. This way we can help you faster.

Best regards,

Albert He

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