Calculate median from calculated column

[Yeztrom]

Hi,

I have de next calculated table.

That table is generated with the next measure.

VAR _VW_Prices_Mode =

FILTER(
            _VW_Prices_Mode_Retalers_No_Model,
             [Year_Week|Max_Rep] IN _VW_Prices_List_Year_Weeek_and_Max_Rep
)

I need to calculate the median of the column product_current_price gruped by the columns master_product_id and related year_week.

I tried with the next measure, but it did not work.

VAR _VW_Prices_Mode_Clear =
SUMMARIZE(
                     _VW_Prices_Mode,
                    [master_product_id],
                    [related year_week],
                   "Mode",MEDIANX(_VW_Prices_Mode,[product_current_price])
)

The result was this.

The "Mode" column was not grouped by  "master_product_id"  and by "related year_week"

I thought use GROUPBY but it seems that it is not compatible with MEDIANX

I would like to know if there is a way to do this.

[amitchandak · Accepted solution]

@Yeztrom , This will take complete column, Try like

If needed use add columns to add the below column

VAR _VW_Prices_Mode_Clear =
SUMMARIZE(
_VW_Prices_Mode,
[master_product_id],
[related year_week],
"price",[product_current_price]
)

New column = MEDIANX(filter(Table, [master_product_id] = earlier([master_product_id]) && [related year_week] = earlier([related year_week]) ), [Price])

or

New column = MEDIANX(filter(Table,  [related year_week] = earlier([related year_week]) ), [Price])

[Yeztrom]

Thanks, 

The solution was:

VAR _VW_Prices_Mode_Clear =

SUMMARIZE(

_VW_Prices_Mode,

[master_product_id],

[related year_week],

"Mode",MEDIANX(FILTER(_VW_Prices_Mode, [master_product_id] = EARLIER([master_product_id]) && [related year_week] = EARLIER([related year_week]) ), [product_current_price])

)