Need help in creating custom new measure for median values

[HellRaizer2310]

I have a data set with 4 columns. Column A = Company Name, Column B = Financial Year, Column C = Days of Working Capital and Column D = Industry Name.

I am trying to create a custom bar chart that shows the median days working capital for each industry for the financial year 2018. Can someone please help with a formula? 

Company Name	Financial Year	Days Working Capital	Industry
A	2018	2	Retail
A	2017	5	Retail
B	2018	3	Retail
B	2017	6	Retail
C	2018	4	Retail
C	2017	7	Retail
D	2018	5	Pharma
D	2017	8	Pharma
E	2018	6	Pharma
E	2017	9	Pharma
F	2018	7	Pharma
F	2017	10	Pharma

[TrentS · Accepted solution]

Hi,

You can create the median with the function in Power BI. 

Median = MEDIAN('Table'[Days Working Capital])

Then it is just a matter of how you want your chart to appear.

Something like?

Lots of options on the display.

That help?

Trent

[v-diye-msft · Accepted solution]

Hi @HellRaizer2310 ,

Let me know if you'd like to get the result like this :

Median = CALCULATE(MEDIAN('Table'[Days Working Capital]),ALL('Table'),VALUES('Table'[Financial Year]),VALUES('Table'[Industry]))

Pbix attached here: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EX0PmQRDUGdHq14Wlvq6gC...

[TrentS · Accepted solution]

Hi,

You can create the median with the function in Power BI. 

Median = MEDIAN('Table'[Days Working Capital])

Then it is just a matter of how you want your chart to appear.

Something like?

Lots of options on the display.

That help?

Trent