all Max

[Fcoatis]

Hi,

I need a measure to calculate the max of an aggregated matrix. The Customer comes from dimCustomer and Value is a sum aggregation. I just need a measure to output the max value for all customers so that I can use it for %, etc

Thanks in advance

[MFelix]

Hi @Fcoatis,

You need to add a measure that looks like this:

MAX Value =
CALCULATE(MAXX(Table;[VALUE]);ALL(Table[ID]))

Should work. 

Regards,

MFelix

[Fcoatis]

Hi @MFelix,

It did not work.

Maybe you can take a look at the example @:

https://drive.google.com/file/d/1WRcRoCkEEZjPy5DbZCpGvZSO0tNfu3uH/view?usp=sharing

Best regards.

[MFelix · Accepted solution]

Hi @Fcoatis,

looking at your data the calculation should be:

.Ratio = CALCULATE(MAXX(Cliente;[.Total]);ALL(Cliente))

In the PBIX file you have sent it gives the following result:

Regards,

MFelix

[Fcoatis]

Thank you very much.

I was confused with which table to use.

Regards