Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |