Forum Discussion
How to include the ALL function in the Medianx calculation using summarized virtual table columns
I am attempting to plot a histogram distribution of incidents by sum of interactions for a selected closed date range and region, using filters. I have created a calculated column to tally the sum of...
This measure gets your expected 27.5 median across all incidents. Note that to get dynamic binning, you'll need a disconnected bin table (not a calculated column, unless you want static binning outside of filter context).
Median Sum =
MEDIANX (
DISTINCT ( incident_interactions[Incident] ),
CALCULATE ( SUM ( incident_interactions[Interactions] ) )
)
Pat
Thanks ppm1 ,I tried your solution and attempted to plot it as a line; however, I expected it to be a straight line with a value of 27.50