Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Is it possible to do it within a single measure?
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.
@ovonel , 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]) )))