MEDIANX and SUMMARIZE - need to exclude 0

[Anonymous]

Hello All!

Median =

MEDIANX(SUMMARIZE(GData,GData[Account],

                            "Contacts",CALCULATE(SUM(GData[TotalContacts]),FILTER(GData,GData[TotalContacts] <>  0  )),"FTE", CALCULATE(AVERAGE(GData[L1FTECount]),FILTER(GData,GData[L1FTECount] <> 0 ))),DIVIDE([Contacts],[FTE]))

It seems that it is still including zeros in the median which is why I am still getting the wrong median number. I hope someone can help with how to eliminate 0 in this measure.

Thanks!

[Anonymous]

This works like a charm. Thank you!

[amitchandak · Accepted solution]

@Anonymous , Try like

MEDIANX(filter(SUMMARIZE(GData,GData[Account],
"Contacts",SUM(GData[TotalContacts])
,"FTE", AVERAGE(GData[L1FTECount])),[Contacts] <> 0 && [FTE]<>0)
,DIVIDE([Contacts],[FTE]))