Medianx Function Returning Blank

[KenDazzo]

I am currently using the following formulas to create a the measure "Median Days in Ship Queue":

Median Days in Ship Queue = MEDIANX(DISTINCT(Shipping[Order_key]),[MEDIAN DAYS IN SHIP])

MEDIAN DAYS IN SHIP = MEDIAN(Shipping[Days_In_Ship_Queue])

However, when I put the measure into a card to display it in Power BI Desktop, it returns "(BLANK)".

I thought that the medianx and median function ignored blank values. I was just hoping to understand the issue. Please can someone shed some light on this for me?

[KenDazzo]

I am currently using the following formulas to create a the measure "Median Days in Ship Queue":

Median Days in Ship Queue = MEDIANX(DISTINCT(Shipping[Order_key]),[MEDIAN DAYS IN SHIP])

MEDIAN DAYS IN SHIP = MEDIAN(Shipping[Days_In_Ship_Queue])

However, when I put the measure into a card to display it in Power BI Desktop, it returns "(BLANK)".

I thought that the medianx and median function ignored blank values. I was just hoping to understand the issue. Please can someone shed some light on this for me?

[Greg_Deckler · Accepted solution]

What happens when you try:

Median Days in Ship Queue = MEDIANX(DISTINCT(Shipping[Order_key]),Shipping[Days_In_Ship_Queue])

?