10-28-2018 10:14 PM
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
10-28-2018 11:52 PM
10-29-2018 07:39 PM
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.