Calculating Median of a column filtered by row

[Throw_11]

I have data whose sample looks like this. There are many more rows here, with -ve and zeroes in AM-PM column

Loc	Actual Margin	Plan Margin	AM-PM
Factory 1	1000	600	400
Factory 1	2000	1000	1000
Factory 1	300	700	-400
Factory 2	2000	1500	500
Factory 2	1000	750	250
Factory 2	100	400	-300

...

I create a 'KPI card' for (AM-PM) which will show the median using for any location filtered. Using the method below, i only get '0' as answer.

How to actually resolve this? I'm new to PBi, and i tried to create a measure with Median DaX function but the result is completely different than what i see from excel. Appreciate any help

[MFelix]

Hi @Throw_11 ,

With the sample data you provided I'm getting values for the median.

Can you please elaborate a little more?Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.