MedianX Function

[shantupm5]

Hello,

I have the below data which is outcome of a Measure, And i want to derive Median of this outcome. I used formula

=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?

[v-yiruan-msft]

Hi @shantupm5 ,

You can update the formula of your measure as below and check if it can return the correct result...

Median = CALCULATE(MEDIAN('Customer'[Achi %]),ALLSELECTED('Customer'))

If the above one can't help you, please provide some raw data in your table 'Customer' (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[shantupm5]

Hello,

The Customer Achi% in my question is output of measure, hence i am not able to apply the above solution. Please advice

Regards
Prashanth

[v-yiruan-msft]

Hi @shantupm5 ,

Please update the formula of measure as below and check if it can return the correct result...

Median = MEDIANX(ALLSELECTED('Customer'),[Achi %])

If the above one can't help you, please provide more raw data in your table 'Customer' (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[shantupm5]

Hello,

Its returning blank results 😞

Regards

Prashanth

[v-yiruan-msft]

Hi @shantupm5 ,

Could you please provide more raw data in your table 'Customer' (exclude sensitive data) with Text format, the formula of measure [Achi %] and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[shantupm5]

Here is the raw data

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 first pass %.

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

[shantupm5]

Hello @v-yiruan-msft

Please can you reivew and advice

Regards

Prashanth