Forum Discussion

shantupm5's avatar
shantupm5
Helper III
3 years ago

MedianX Function

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...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
shantupm5
Helper III
3 years ago

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 NameFirst Pass OrdersTotal 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 C34373733
Customer C37854292
Customer C38884277
Customer C29063141
Customer C29173147
Customer C36014200
Customer C30073535
Customer C34353787
Customer C34203915
Customer C26202963
Customer C23642687
Customer E18102079
Customer E21252310
Customer E19932106
Customer E14871713
Customer E15841828
Customer E19592386
Customer E21422486
Customer E19122151
Customer E20712308
Customer E16221809
Customer E19402190
Customer E20222264
Customer D 1344
Customer F14004095
Customer F12003280
Customer F15003755
Customer F17003863
Customer F15003532
Customer F14004303
Customer F12504286
Customer F13004466
Customer F15004628
Customer F17005324
Customer F15505969
Customer F14504858
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 C27413259
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 F142327512
Customer F147826382
Customer F136526497
Customer F133326847
Customer F176524261
Customer F165427660
Customer F178224594
Customer F180325235
Customer F179925503
Customer F171222412
Customer F189224786
Customer F180423821
  • shantupm5's avatar
    shantupm5
    Helper III
    3 years ago

    Hello @v-yiruan-msft

     

    Please can you reivew and advice

     

    Regards

    Prashanth