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 - September 2025
Check out the September 2025 Power BI update to learn about new features.
Fabric Community Update - August 2025
Find out what's new and trending in the Fabric community.
