Have the Median Value repeated for every row. Based on Table column, not the data set loaded

[Vern2022]

Hi all,

How do I accomplish having the Median value repeated for every row. When I apply the Median function, it just applies it to the measure concerned but doensn't look at the whole entire table column.

I don't want the median of the data set loaded either, I just want the Median of the measure to be repeated for every row, whilst ordering the numbers itself within the expression given the numbers are not in sorted order in the table itself. I will not sort the table as this needs to apply to a pivot already sorted by something else. Can someone tell me how this is accomplished please?

Many thanks.

[Aditya_Chitale]

can you share sample data along with required output ?

Regards,

Aditya

[Vegar]

Let's assume you are using the measure median([Value]) . That measure will calculate the median aggregatet per dimension combination in your table. In order to get a total median value for the whole datavetenskap, ignoring the dimensions in your table,  then you need to use the TOTAL attribute. 

Try this:

median( TOTAL [Value])

If this is not the right solution then please provide an example and an expected  output of that example.