Forum Discussion
Calculation for all but the selected filter value
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.
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])))
3 Replies
- amitchandak
Super User
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])))
- amitchandak
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.