Forum Discussion

Fcoatis's avatar
Fcoatis
Post 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 customers so that I can use it for %, etc

 


Thanks in advance

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

4 Replies