Forum Discussion

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

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

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    8 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
      8 years ago

      Thank you very much.

       

      I was confused with which table to use.

       

      Regards