Calculation for all but the selected filter value

[Anonymous]

I'm new to DAX and still learning Power BI. I would like a calculation that filters all but the selected value in a slicer.  In example (this code does not work):

cal_all_but_isem_gr_fa16_fa17_ret_rate =

CALCULATE(SUM(hu_ir_enrollment_retention_graduation[gr_fall16_fall17_ret]),

(FILTER(hu_ir_enrollment_retention_graduation),hu_ir_enrollment_retention_graduation[stu_div] = "GR" && NOT (SELECTEDVALUE)/

CALCULATE(SUM(hu_ir_enrollment_retention_graduation[gr_fall_2016_cohort]),

(FILTER(hu_ir_enrollment_retention_graduation),hu_ir_enrollment_retention_graduation[stu_div] = "GR" && NOT (SELECTEDVALUE)))

What is the best way to accomplish this? Please advise. Thank you.

[amitchandak · Accepted solution]

Refer

Sum Not Selected = CALCULATE(sum(Sales[Sales]),EXCEPT(ALL(Customer[Age Group]),ALLSELECTED(Customer[Age Group])))

Try

 CALCULATE(sum(hu_ir_enrollment_retention_graduation[gr_fall_2016_cohort]),EXCEPT(ALL(hu_ir_enrollment_retention_graduation[stu_div]),ALLSELECTED(hu_ir_enrollment_retention_graduation[stu_div])))

[Anonymous]

Thank You. This formula is what I needed. 

[amitchandak]

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