MedianX is not working Please Help

[Sudhavi_84]

Hi Experts,

I have a PBIX model. Please open link below to download

https://1drv.ms/u/s!An2H1J0iSc93a2if_OCNzJRquIc?e=T1gyog

I am able to acheive Measure for Total and Average but Median is showing incorrect value

Median value should show 47894 but for some reason it is showing inaccurate value.

In Excel I am getting correct Median value please see below

[Sudhavi_84 · Accepted solution]

This is fixed by @OwenAuger (Please see below link)

and I learned something new:-)

https://community.powerbi.com/t5/Desktop/MEDIAN-calculation-giving-strange-results/m-p/1915718#M7324...

[V-pazhen-msft]

@Sudhavi_84 

Try summarizecolumns to a table first then create a median measure.

Median =

var table1 = SUMMARIZECOLUMNS(Mstone[Project], "cost measure",[My Measure])

return MEDIANX(table1,[cost measure])

or 

Table = SUMMARIZECOLUMNS(Mstone[Project], "cost measure",[My Measure])

Median measure = median([cost measure])

Paul Zheng _ Community Support Team

[Sudhavi_84]

When I use below measure in Card Visual I am getting correct Median

Median =

var table1 = SUMMARIZECOLUMNS(Mstone[Project], "cost measure",[My Measure])

return MEDIANX(table1,[cost measure])

So I created a similar measure as you specified and when I am using in Table visual it is coming with error

Median measure = median([cost measure])

Please help

[Sudhavi_84]

Hi @V-pazhen-msft .

I created Measure for summarise columns as below as you specified

But median function is not allowing to select measure name. I think I can select only Table/column name isn't it?

I am getting error. Could you please let me know where I am wrong here

Thank you

[Sudhavi_84]

I am getting correct Median Value in Card visual with below measure but how can I acheive this in to left table please because if you see in left table median is showing incorrect?

My Measure =

(Working Good Excluding total)

VAR XYZMaxDate = CALCULATE(MAX(Mstone[Project Level Date]),Mstone[Project Level] = "XYZ",Mstone[Desc]="Current")

VAR ABCMaxDate = CALCULATE(MAX(Mstone[Project Level Date]),Mstone[Project Level] = "ABC",Mstone[Desc]="Current")

var Prj = SELECTEDVALUE(Mstone[Project])

VAR TOT= CALCULATE(SUM(Fact[Cost]),FILTER('Fact','Fact'[Per] >=XYZMaxDate && 'Fact'[Per]<=ABCMaxDate),Master[Projects]=Prj,Fact[Desc]="Current")

Return TOT

MeasureTotal = SUMX(VALUES(Mstone[Project]),[My Measure])  Working good including Total

Average = AVERAGEX(VALUES(Mstone[Project]),[My Measure])  Working good for Average

Median = MEDIANX(VALUES(Mstone[Project]),[My Measure])  (This is the issue for me)

Please help me to fix this. I attached One drive link for PBIX file.