how to get the max and total per group in a single measure?

[Anonymous]

I aim to get the total and the max for each C% group but I am unable…

Given the below data, I would like to do  Total/MAX (per C% group), that is:

• 50/50 for C1
• 35/25 for C2
• 35/20 for C3

Is it possible to do it within a single measure?

[Anonymous]

Everything (well, almost) is possible. Can you please give us a sample of your data to work with? In text form so that it can be copied and pasted. Thanks.

[amitchandak]

@Anonymous , Try like

assume you habve three row column in matrix group1,group2, group3,, group4 and you have measure total

Try a measure like

divide([total], calculate(maxX(values(Table[group4]),[total]),filter(allselected(Table), table[group1] =max(table[group1]) && table[group2] =max(table[group2]) && table[group3] =max(table[group3]) )))