Forum Discussion
MedianX Function
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
Hello,
Its returning blank results 😞
Regards
Prashanth
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
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