Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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