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 am not sure how to go about this. The table is named Table, with two columns, Category and Rating. If my data was:
Category Rating
A 2
B 3
C 4
SimpleMedian = Calculate(Median(Table.Rating)) The SimpleMedian here is 3. Easy.
Instead I have for Data:
A 2
A 6
A 4
B 1
B 8
B 7
C 3
C 6
C 20
SimpleSum = Calculate(SUM(table.Rating)) which gives me the values below:
A 12
B 16
C 29
The median of that result is 16, but how do I create the measure(s) to get that result? Median likes columns, not measures...
Ultimately, for a function that requires a column, How do I get it to work with a calculated aggregate measure instead?
Thanx
Phil
Solved! Go to Solution.
create a calculated table
Table 2 = SUMMARIZE('Table','Table'[Category],"Rating",sum('Table'[Rating]))
Add the median measure
med = MEDIAN('Table 2'[Rating])
Or if you want to be cute you can do the calculated table as part of the measure
med = MEDIANX(SUMMARIZE('Table','Table'[Category],"Rating",sum('Table'[Rating])),[Rating])
create a calculated table
Table 2 = SUMMARIZE('Table','Table'[Category],"Rating",sum('Table'[Rating]))
Add the median measure
med = MEDIAN('Table 2'[Rating])
Or if you want to be cute you can do the calculated table as part of the measure
med = MEDIANX(SUMMARIZE('Table','Table'[Category],"Rating",sum('Table'[Rating])),[Rating])
A Calculated table doesn't work, because I need dynamic results. However, using it in a measure like that was the perfect answer. Thank you very much!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |