FcoatisPost Patron7 years agoSolvedall 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...Show MoreMFelix to Fcoatis7 years agoHi 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 to Fcoatis7 years agoHi 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 to Fcoatis7 years agoHi 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
MFelixSuper User7 years agoHi 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
FcoatisPost Patron to MFelix7 years agoThank you very much. I was confused with which table to use. Regards
Related contentMax CountMAX DateMax Datenvarchar(max) - 4000 limit overcomecalculate with max() function
