Reply
Regular Visitor
Posts: 31
Registered: ‎08-22-2018

Case statement in DAX

Hi

 

Here i have a DAX Statement as

 

CASE (WHEN stricker<>'' OR NONSTRIKER<>'' THEN (RUNS + (CASE WHEN BYES = 0 AND LEGBYES = 0 THEN OVERTHROW ELSE 0 END))
WHEN @BOWLER<>'' THEN (RUNS + WIDE+ (CASE WHEN BALL.NOBALL > 0 AND (BALL.BYES > 0 OR BALL.LEGBYES > 0) THEN BALL.BYES + BALL.NOBALL + BALL.LEGBYES
WHEN BALL.NOBALL > 0 AND BALL.BYES = 0 AND BALL.LEGBYES = 0 THEN BALL.NOBALL
ELSE 0 END) + (CASE WHEN BYES = 0 AND LEGBYES = 0 THEN OVERTHROW ELSE 0 END))
ELSE GRANDTOTAL END ) AS RUNS

 

 

But it is showing as error in my Dax i am  unable to find out the error why it is not executing the statement

 

 

When i am 

New Contributor
Posts: 504
Registered: ‎02-16-2017

Re: Case statement in DAX

[ Edited ]

@JAVED Are you sure this is DAX?? I don't think DAX looks like above.

Regular Visitor
Posts: 31
Registered: ‎08-22-2018

Re: Case statement in DAX

Sorry, this is Sql statement i have to convert to DAX

New Contributor
Posts: 504
Registered: ‎02-16-2017

Re: Case statement in DAX

Hi @JAVED,


Try Using SWITCH or IF-ELSE . CASE is not supported in DAX.

 

Also, you have posted the question on wrong forum. This forum is used for reporting Bugs.
If you need any technical help you should post the question on this forum.

 

Regards,

Prateek Raina

Regular Visitor
Posts: 31
Registered: ‎08-22-2018

Re: Case statement in DAX

Thank you @prateekraina

Highlighted
Moderator
Posts: 9,540
Registered: ‎03-10-2016

Re: Case statement in DAX

@JAVED,

As prateekraina's post, you would need to use Switch or if statement in DAX. If you have questions about the DAX, please share sample data of your tables and post expected result following the guide in this thread: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.