Forum Discussion

Frequent Visitor

8 years ago

Solved

Median PowerBI vs Excel

Hi All, I am using Median function for some fields. For two fields, the median value in excel is different than what I get in PowerBI. The one is excel is what I want. Seems like excel is ignorin...

Need Help

ace_SB
8 years ago
I think I got it:

MedScore = ROUND(
CALCULATE(
medianx(FILTER(vw_ABC, vw_ABC[Score1]<> BLANK()),
vw_ABC[Score1]) ,

TREATAS(VALUES('vw_Option'[StuName]),vw_ABC[IStuName])
),0
)