Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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):
Solved! Go to 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])))
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])))
Thank You. This formula is what I needed.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
103 | |
91 | |
79 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |