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.
Hi there,
I'm trying to find a way to get the total of all values which are eqaul to maximum value of a different column in the same table. a simplified excel example per below.
I've got a measure defining the maximum value. I was thinking of using a different measure using this 'maximum value' measure as a condition using a filter. something like this:
calculate(sum(table[value]),filter(table, table[ageing]=[maximumageing].
This appears not to give the correct value though (which in above example would need to be 615.
suggestions are well appreciated! thanks
Solved! Go to Solution.
@Anonymous
Try placing the MEASURE in a varaiable first
= VAR mymeasure = [maximumageing] RETURN CALCULATE ( SUM ( table[value] ), FILTER ( table, table[ageing] = mymeasure ) )
@Anonymous
Try placing the MEASURE in a varaiable first
= VAR mymeasure = [maximumageing] RETURN CALCULATE ( SUM ( table[value] ), FILTER ( table, table[ageing] = mymeasure ) )
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |