Calculate Median Value

[shantupm5]

Hello,

I have the below raw data where i have First Pass Orders and Total Orders,

I had a measure to calcuate Customer wise First Pass %, which is sum of First pass orders / Total Orders. 

Then i need the median out of the results to identify the medain of first pass %.

I used the formulat =CALCULATE(MEDIANX(VALUES('Customer[Customer]),[Achi %])) and i get the Medain as 3.84%.
How ever when i compute the same data in excel sheet and use fomula =MEDIAN(J7:J12), i get the Median value as 61%.

Please can you let me know what is accurate and right way of calculating the Median Value?

Please advice

Customer Name	First Pass Orders	Total Orders
Customer A		0
Customer A		0
Customer A		0
Customer A		0
Customer B		0
Customer B		0
Customer B		0
Customer B		0
Customer B		7
Customer B		6
Customer D		1022
Customer D		879
Customer D		888
Customer D		640
Customer D		371
Customer D		690
Customer D		549
Customer D		1246
Customer D		942
Customer D		572
Customer D		864
Customer C	3437	3733
Customer C	3785	4292
Customer C	3888	4277
Customer C	2906	3141
Customer C	2917	3147
Customer C	3601	4200
Customer C	3007	3535
Customer C	3435	3787
Customer C	3420	3915
Customer C	2620	2963
Customer C	2364	2687
Customer E	1810	2079
Customer E	2125	2310
Customer E	1993	2106
Customer E	1487	1713
Customer E	1584	1828
Customer E	1959	2386
Customer E	2142	2486
Customer E	1912	2151
Customer E	2071	2308
Customer E	1622	1809
Customer E	1940	2190
Customer E	2022	2264
Customer D		1344
Customer F	1400	4095
Customer F	1200	3280
Customer F	1500	3755
Customer F	1700	3863
Customer F	1500	3532
Customer F	1400	4303
Customer F	1250	4286
Customer F	1300	4466
Customer F	1500	4628
Customer F	1700	5324
Customer F	1550	5969
Customer F	1450	4858
Customer A		470
Customer A		470
Customer A		470
Customer A		46
Customer A		11
Customer A		6
Customer A		2
Customer A		5
Customer B		175
Customer B		149
Customer B		87
Customer B		23
Customer B		27
Customer B		27
Customer C	2741	3259
Customer G		59386
Customer G		59381
Customer G		59374
Customer G		59365
Customer G		59381
Customer G		59377
Customer G		59377
Customer G		59375
Customer G		59296
Customer G		59423
Customer G		59415
Customer G		59321
Customer F	1423	27512
Customer F	1478	26382
Customer F	1365	26497
Customer F	1333	26847
Customer F	1765	24261
Customer F	1654	27660
Customer F	1782	24594
Customer F	1803	25235
Customer F	1799	25503
Customer F	1712	22412
Customer F	1892	24786
Customer F	1804	23821

[some_bih]

Hi @shantupm5 check for blanks, 

• MEDIANX does not ignore blanks; however, MEDIAN does ignore blanks

https://learn.microsoft.com/en-us/dax/medianx-function-dax 

I hope this help in explaining difference in results

[Kishore_KVN]

Hello @shantupm5 , 

It is not clear on which you want to create median, can you please elaborate and expalin your rquirement properly. 

[shantupm5]

Hello @Kishore_KVN 

Thanks for your response, 

I want to have a median for the output of the measure where i have calcuated the Account wise First Pass % (Sum of First Pass Orders / Sum of Total order processed).

Please advice

Prashanth