calculated columns within a measure

[mypowerbi1]

Hi,

I am trying to calculate the median of a value based on some conditions. 

This is my dax which i am trying with:

Median =

var med = CALCULATE(IF([Fixed_Rate_CY]<0,0,IF([Fixed_Rate_CY]>0.10,0,[Fixed_Rate_CY])))

var med1 = CALCULATE(IF([Fixed_Rate_CY]>0.10,MEDIAN(med),med))

return med1

As MEDIAN function only accepts column refrence, it gives me an error.

please suggest how to make var med as a column, so it can be used as a column to calculate the MEDIAN in var med1.

Thanks

[Greg_Deckler]

@mypowerbi1 To **bleep** With MEDIAN - Microsoft Power BI Community