Max value of a filtered Table

[baronraghu]

Hi All,

I am trying to find out the maximum value of the column highlighted in Red

The highlighted Red column is A calculated Measure and the columns in Blue is filtered. 

I used MAXX& ALL EXCEPT. However it is giving maximum value of an unfiltered table. Plz help

[v-angzheng-msft · Accepted solution]

Hi, @baronraghu 

Try to replace ALL EXCEPT with FILTER+ALL+MAX  in your measures.

like:

a =
CALCULATE ( SUM ( [value] ), ALLEXCEPT ( table, 'table'[name], 'table'[age] ) )

b =
CALCULATE (SUM ( [value] ),
FILTER (ALL ( table ),'table'[name] = MAX ( 'table'[name] )&& 'table'[age] = MAX ('table'[age] ))
)

If it doesn't work, could you please consdier sharing more details about it and posting expected result so it is clear on what needs to be implemented?  And It would be great if there is a sample file without any sesentive information here. It makes it easier to give you a solution.

Best Regards,
Community Support Team _ Zeon Zheng

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

[baronraghu]

 Hi, 

its not working , Please note there are two columns highlighted in  blue.

[mh2587]

Measure =
MAXX ( ALLSELECTED ( 'Table'[Blue Col] ), [Red Col] )