Calculating average excluding zeros ignoring slicer for a measure in power bi

Question

I want to calculate the average scores of students exclude the scores that are zero

measure= calculate(average(table[score]),filter(table, table[score]<>0))

And I want to compare the measure by selecting student against the slicer

ew measure= calculate(average(table[score]),all(table[student]),filter(table, table[score]<>0))

How can use the new measure in the score and ignore the slicer 

Answer 1

Use AverageX and IF in calculated feilds

Average Excluding Zero =
AVERAGEX (
    Table,
    IF ( Table[Score] <> 0, Table[Score] )
)

All Students Average Excluding Zero =
CALCULATE (
    [Average Excluding Zero],
    ALL ( Table[Student] ) 

) 

If you want to learn more about Power BI, then read the Power BI Tutorial. Also, enroll in Power BI Training to become proficient in this BI tool.