Not getting correct value of median

[mohittimpus]

I have 2 Tables:

1) Date

2) Employee_Info

'Date' master table is connected with Employee_Info.

I have created one table visualization inside Employe_Info.pbix file. Table is filter with Year.

1) Inside Employee_Info.pbix "Fiscal Month" is taking from Date table, after that I created one Measure with name "#Count Employee" which calculate total 'Count of Employee' column.

#Count Employee = CALCULATE(SUM(Employee_Info[Count of Employee]))

2) After that I created  Measure with name "Rank of Employee" Which is getting rank of Employee based on fiscal Month.

Rank of Employee = if([#Count Employee]>0 || [#Count Employee]<>BLANK(),RANKX (FILTER(ALLSELECTED('Date'[Fiscal Month]),[#Count Employee]<>0 || [#Count Employee]<>BLANK()), [#Count Employee],,ASC,Dense))

3) Finally I am calculating 'Median' of "#Count Employee" for that I have created Measure with name "Median_of_Emp" with couple of steps followed inside "Median_of_Emp" Measure. 

Median_of_Employee =

VAR _tbl =

SUMMARIZE(

CALCULATETABLE(

'Date',

ALLSELECTED( 'Date'[Fiscal Month] )

),

'Date'[Fiscal Month]

)

RETURN

IF([#Count Employee]>0,

INT(MEDIANX( _tbl, [#Count Employee]))

)

******Now I am not getting correct value 63.64 or Roundup 64 for  "Median_of_Employee" Measure. How to get correct value in Median_of_Employee Measure.

Below I am showing image:

@Mariusz  any Idea about it.

[Mariusz · Accepted solution]

Hi @mohittimpus 

Please see the below calculation result of a Median function in Excel based on this sample.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.