Hai All Need help on this why this error is happening
The requirement is a user selects any year, He wants to see that year's value otherwise he wants to see sum value
@AlanP514 Your first IF statement is broken. Why are you even using an IF statement there? IF statements need to have at least 2 arguments. You have 1 argument. Basically you are saying IF the DIVIDE of these two numbers then do nothing else do nothing. Can't work like that. Just drop the IF or decide what you want to return if true or false.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
@AlanP514 Your first IF statement is broken. Why are you even using an IF statement there? IF statements need to have at least 2 arguments. You have 1 argument. Basically you are saying IF the DIVIDE of these two numbers then do nothing else do nothing. Can't work like that. Just drop the IF or decide what you want to return if true or false.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
