Show MAX over all rows, but keep filter on page

[dabrooze]

Hi,

I have a table with companie names and their value.

Company	Value
A	10
B	50
C	30
D	20
E	10
F	5
G	60

I have a page with a report that's showing the max value for each of these companies
CALCULATE ( MAX (  [value] ) , ALL ( [ company] ) )

Company	Value	Max value
A	10	60
B	50	60
C	30	60
D	20	60
E	10	60
F	5	60
G	60	60

On the page itself is a filter on companies. If I filter out company's G and B, I now still land on a max value of 60.

Company	Value	Max value
A	10	60
C	30	60
D	20	60
E	10	60
F	5	60

I'm looking for a DAX formula that's finding the MAX value of the companies that I filtered on the page itself. Based on these companies the output should then return 30.

Company	Value	Max value
A	10	30
C	30	30
D	20	30
E	10	30
F	5	30

How to achieve this?

[dabrooze · Accepted solution]

Thanks @Uzi2019 and @Kedar_Pande ,

Have used your inputs to land on the following measure that worked for me:

CALCULATE (
 MAX ( [Value] ) ,  
     ALLSELECTED ( [Company ) ,
     ALLEXCEPT( [companies table] , [Company] )
)

Thanks!

[Uzi2019]

Hi @dabrooze 

Try below dax measure

max company = CALCULATE(MAX(company[Value]),ALLSELECTED(company[Company]))

I hope I answered your question!

[Kedar_Pande]

DAX Formula:

Max_Filtered_Value = MAX(Table[Value])

This measure calculates the maximum value based on the current filter context applied to the visual. When you filter out companies (like G and B), the max value will only consider the remaining visible companies.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn