Median line in column chart

[Justas4478]

Hi, I have clusterd column chart.

I was trying to add medina line for 98%, but it wasnt working.
And I was hoping end result would look like this.

Unfortunatelly no measure does the job.
This is the measure of the data in the columns: 

% Fulfilment = 'Outbound Delivery'[Total Actual]/'Outbound Delivery'[Total Demand]

I tried to just create static % measure like this

Median value = 0.98

And it partialy worked, but it as well displayed floors that do not have any data, which is not what I hope.

Anyone know what would be correct way to do this?
Thanks

[Uzi2019 · Accepted solution]

Hi @Justas4478 
Just take your measure in line value under Analyses setting

like above image.
I hope I answered your question!

[Greg_Deckler]

@Justas4478 This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

This might also help: To **bleep** With MEDIAN - Microsoft Fabric Community