Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
The DAX measure code below returns the engagement count and also term and year. I only want the selected term to show for example "Fall", but I get both Fall and Spring as shown below.
If I remove one If statement and run for either "Fall" or "Spring", I generate the correct ouput.
I am sure the issue is with the commas, but I am not sure how to make this an (If, Yes, No) statement.
I greatly appreeciate your assistance with t his formatting issue.
-----------------------------------------------------------------------------------------------------------------------------
VAR _program = Enrollment[ProgramSelection]
@Anonymous Try using SWITCH instead of nested IF statements.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 6 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 18 | |
| 14 | |
| 14 |