Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]) )))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |