dax QUERY WORKING WEIRDLY

[Anonymous]

Hi all

I have the following query, its not working for "PRESSURE", However, if I create a separate query for the same its working.

I am not getting any error message either.

Column =

SWITCH(TRUE(),AND([SAPACTDES-3]="VESSEL",[SAPACTDES-2]="EXT"),"EXT-VESSEL"

,AND([SAPACTDES-4]="VESSEL",[SAPACTDES-2]="EXT"),"EXT-VESSEL"

,AND([SAPACTDES-5]="VESSEL",[SAPACTDES-2]="EXT"),"EXT-VESSEL"

,AND([SAPACTDES-6]="VESSEL",[SAPACTDES-2]="EXT"),"EXT-VESSEL"

,AND([SAPACTDES-7]="VESSEL",[SAPACTDES-2]="EXT"),"EXT-VESSEL"

,AND([SAPACTDES-3]="SEPARATOR",[SAPACTDES-2]="EXT"),"EXT-SEPARATOR"

,AND([SAPACTDES-4]="SEPARATOR",[SAPACTDES-2]="EXT"),"EXT-SEPARATOR"

,AND([SAPACTDES-5]="SEPARATOR",[SAPACTDES-2]="EXT"),"EXT-SEPARATOR"

,AND([SAPACTDES-6]="SEPARATOR",[SAPACTDES-2]="EXT"),"EXT-SEPARATOR"

,AND([SAPACTDES-7]="SEPARATOR",[SAPACTDES-2]="EXT"),"EXT-SEPARATOR"

,AND([SAPACTDES-3]="PRESSURE",[SAPACTDES-2]="EXT"),"EXT-PRESSURE"

,AND([SAPACTDES-4]="PRESSURE",[SAPACTDES-2]="EXT"),"EXT-PRESSURE"

,AND([SAPACTDES-5]="PRESSURE",[SAPACTDES-2]="EXT"),"EXT-PRESSURE"

,AND([SAPACTDES-6]="PRESSURE",[SAPACTDES-2]="EXT"),"EXT-PRESSURE"

,AND([SAPACTDES-7]="PRESSURE",[SAPACTDES-2]="EXT"),"EXT-PRESSURE"),"OTHER EQUIPMENT")

[wdx223_Daniel]

@Anonymous think it might be that swith function can not reach that step because previous conditions has got a True, or the combinations not be listed completely.

[amitchandak]

@Anonymous , Other one misplace of parenthesis at last every thing else seems fine.

Can you share a sample pbix after removing sensitive data.

SWITCH(TRUE(),AND([SAPACTDES-3]="VESSEL",[SAPACTDES-2]="EXT"),"EXT-VESSEL"
,AND([SAPACTDES-4]="VESSEL",[SAPACTDES-2]="EXT"),"EXT-VESSEL"
,AND([SAPACTDES-5]="VESSEL",[SAPACTDES-2]="EXT"),"EXT-VESSEL"
,AND([SAPACTDES-6]="VESSEL",[SAPACTDES-2]="EXT"),"EXT-VESSEL"
,AND([SAPACTDES-7]="VESSEL",[SAPACTDES-2]="EXT"),"EXT-VESSEL"
,AND([SAPACTDES-3]="SEPARATOR",[SAPACTDES-2]="EXT"),"EXT-SEPARATOR"
,AND([SAPACTDES-4]="SEPARATOR",[SAPACTDES-2]="EXT"),"EXT-SEPARATOR"
,AND([SAPACTDES-5]="SEPARATOR",[SAPACTDES-2]="EXT"),"EXT-SEPARATOR"
,AND([SAPACTDES-6]="SEPARATOR",[SAPACTDES-2]="EXT"),"EXT-SEPARATOR"
,AND([SAPACTDES-7]="SEPARATOR",[SAPACTDES-2]="EXT"),"EXT-SEPARATOR"
,AND([SAPACTDES-3]="PRESSURE",[SAPACTDES-2]="EXT"),"EXT-PRESSURE"
,AND([SAPACTDES-4]="PRESSURE",[SAPACTDES-2]="EXT"),"EXT-PRESSURE"
,AND([SAPACTDES-5]="PRESSURE",[SAPACTDES-2]="EXT"),"EXT-PRESSURE"
,AND([SAPACTDES-6]="PRESSURE",[SAPACTDES-2]="EXT"),"EXT-PRESSURE"
,AND([SAPACTDES-7]="PRESSURE",[SAPACTDES-2]="EXT"),"EXT-PRESSURE","OTHER EQUIPMENT")

[Anonymous]

The query was working fine, i had confused myself.

[Fowmy]

@Anonymous 

I didn't get your question right, please explain clearly.

Your last line closing bracket before "OTHER EQUIPMENT" is not required.

,AND([SAPACTDES-7]="PRESSURE",[SAPACTDES-2]="EXT"),"EXT-PRESSURE","OTHER EQUIPMENT")

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn