Forum Discussion

Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost Patron
7 years ago
Solved

all Max

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 custom...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    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

MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

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's avatar
    Fcoatis
    Icon for Post Patron rankPost Patron
    7 years ago

    Thank you very much.

     

    I was confused with which table to use.

     

    Regards