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;
or
Richard
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;
Excel Formula:
; MAX( Table1[Units] )
Then, CALCULATE([MaxU],(FILTER(ALL(Table1[Item]) ,Table1[Item]= "A") )
or
Excel Formula:
MAXX(FILTER(ALL(Table1[Item],Table1[Units]),Table1[Item] = "A"),Table1[Units] )
Richard