topic Median function on a MAX column in Desktop

Median function on a MAX column

Anonymous — Wed, 09 Mar 2022 16:10:12 GMT

Hello,

I am trying to calculate the median on a max column (Max_DelaiH). I had to create a max column because I have duplicates.

I tried

Tmps_Median = VAR __table4 = SUMMARIZE('Documents',[No-QR7],"__value4",[MAX_DelaiH])

RETURN

IF(HASONEVALUE(Documents[No-QR7]),[MAX_DelaiH],MEDIAN(__table4,[__value4]))

But I can't do the MEDIAN function on a line.

Can anybody help me? Is there a median function for a line?

v-chenwuz-msft — Mon, 14 Mar 2022 07:00:40 GMT

Hi Anonymous ,

Please add function CALCULATE() out side the MEDIAN function or MEDIANX(). Like the following expression.

Tmps_Median =

VAR __table4 = SUMMARIZE('Documents',[No-QR7],"__value4",[MAX_DelaiH])

RETURN

IF(HASONEVALUE(Documents[No-QR7]),[MAX_DelaiH],

CALCULATE(MEDIAN([__value4]), '__table4')

)

Tmps_Median =

VAR __table4 = SUMMARIZE('Documents',[No-QR7],"__value4",[MAX_DelaiH])

RETURN

IF(HASONEVALUE(Documents[No-QR7]),[MAX_DelaiH],

MEDIANX(__table4,[__value4])

)

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous — Mon, 14 Mar 2022 13:35:13 GMT

Thank you, I will try it but I realised I didn't need to do it in the end.