Power BI DAX - Running the MEDIAN or MEDIANX formula for a calculated column gives error message

[nilotpalc]

I have been trying to generate a calculated column within Power BI Desktop using the MEDIAN formula to get the median age. I checked to see if there were any inconsistencies like text data or blank data within the Age column but, did not find any such instances. The error message is as follows -

Expressions that yield variant data-type cannot be used to define calculated columns.

I created a median measure and no error was observed. I also ran the statistic function in the query stage and it gave me, 27 as the median age for the entire dataset. I expected the data column to have a single value equal to 27 being shown in the calculated column.

Any help will be greatly appreciated.

Error Message

Age Column Format

[nilotpalc]

Hi all,

I found the answer on the link here

[Greg_Deckler]

That's a good one @nilotpalc , will have to remember that!! 🙂

[Greg_Deckler]

What is the formula for your Age column? Can you provide the file?

[nilotpalc]

@Greg_Deckler  The Age Column is just a number and there is no formula for the same.

The xlsx file used is shared on this link