MAX value best practice

[dicken]

Hi
When trying to find the maximum value with a filter condition is there any difference between these two methods and
which if either is regarded as better;

; MAX( Table1[Units] ) 
  Then, CALCULATE([MaxU],(FILTER(ALL(Table1[Item]) ,Table1[Item]= "A") )

or

MAXX(FILTER(ALL(Table1[Item],Table1[Units]),Table1[Item] = "A"),Table1[Units] )

Richard

 

[jdellasala]

Hi
When trying to find the maximum value with a filter condition is there any difference between these two methods and
which if either is regarded as better;

; MAX( Table1[Units] )
  Then, CALCULATE([MaxU],(FILTER(ALL(Table1[Item]) ,Table1[Item]= "A") )

or

MAXX(FILTER(ALL(Table1[Item],Table1[Units]),Table1[Item] = "A"),Table1[Units] )

Richard

CALCULATE isn't an Excel function, it's a DAX function. I assume MAXX is a typo. However unless the Item column in Table1 is only single upper case characters (A;B;C), I don't think you're going to get what you're looking for.
I suggest posting some sample data along with a sample result using XL2BB as it's unclear what the source data or goal is.

 

[RoryA]

I assume MAXX is a typo

No, this is all DAX. This is the power tools forum, after all.

 

[dicken]

No, this is all DAX. This is the power tools forum, after all.

but power pivot, which uses DAX comes under power tools,

Power BI, Power Pivot, Power Query (Get and Transform), Power View, and Power Map

no MAXX is what I used? MAXX to take the filtered table, I just used MAX with the calculate version.
Anyway is one better than the other?

RD

 

[jdellasala]

but power pivot, which uses DAX comes under power tools,

Power BI, Power Pivot, Power Query (Get and Transform), Power View, and Power Map

no MAXX is what I used? MAXX to take the filtered table, I just used MAX with the calculate version.
Anyway is one better than the other?

RD

Never mind. I didn't realize that was DAX.

 

[dicken]

Never mind. I didn't realize that was DAX.

I should have put DAX in the title, a slip up sorry.

RD