AverageX working but Medianx returning blank

[Robi2]

I am trying to get a median value from a Summarize table function, but it's returning blank.

If I switch to AverageX I do get a value back.

This is my query: 

On Demand Clicks Median = CALCULATE(MEDIANX(
	SUMMARIZE(Analytics,Analytics[User Token],"On Demand Count",CALCULATE(COUNTROWS(Analytics), Analytics[Event Name]="On-Demand")), [On Demand Count]))

So if I switch to AverageX it does work.

Also this function of summarize also works correctly if I view it in a table.

SUMMARIZE(Analytics,Analytics[User Token],"On Demand Count",CALCULATE(COUNTROWS(Analytics), Analytics[Event Name]="On-Demand") 

 Do you know what could be wrong?

Thanks,

Robert

[v-sihou-msft]

@Robi2

I can't reproduce your issue. I tried a similar forumula as yours. It can return correct result.

Can you share some sample data?

Regards,