Maxx working vs Minx not working

[Anonymous]

Hello, I have a measure to calculate the difference in percentage billed (see in Results section).

% Billed = sum(Hours_billed[Hours_billed])/sum(Hours_planned[Hours_planned])-1

I want to get the max and min value of those results. As you can see, Max value 14,81% is right but -29,82% is not. I use the exact same formula logic for both measures. 

Max = Maxx(all(Employees[Office]),[% Billed])

Min = Minx(all(Employees[Office]),[% Billed])

I would like to understand why the Minx isn't working properly. Thank you

[Anonymous · Accepted solution]

Hello amitchandak responded but his message disappeared. However both of his solutions were working. Thank you

Max = Maxx(values(Employees[name]),[% Billed])
Min = Minx(values(Employees[name]),[% Billed])

or

Max = calculate( Maxx(values(Employees[name]),[% Billed]) , all(Employees) )
Min = calculate( Minx(values(Employees[name]),[% Billed]) , all(Employees) )

[Greg_Deckler]

@Anonymous Pretty sure that needs to be:

Max = Maxx(SUMMARIZE(all('Employees'),[Office],"__Billed",[% Billed]),[__Billed])

Min = Minx(SUMMARIZE(all('Employees'),[Office],"__Billed",[% Billed]),[__Billed])

[Anonymous]

Hello, unfortunately your formula gives the same result. I posted the solution above. Thank you