Better way of writing Nested IF

[BishwaR]

I have a dax like

status =

          IF ( Number < 10,"Poor",

          IF (Color = "Black", "Good")," No Comment"

I have seen people writing such condition writing IF only once ( I may be wrong)

Status = IF ( Number <10,Color = "Black")---- 

Is it possible ?

[AllisonKennedy · Accepted solution]

@BishwaR  You can use && for AND and || for OR conditions in filters. I'll be writing a blog on this soon as you're the second person in as many days to have a similar question. 

You can either use SWITCH or continue with IF. Here is how you could write using SWITCH (note order matters so anything less than 10 will be poor, even if the color is black):

status =

          SWITCH ( TRUE()
, Number < 10,"Poor"

, Color = "Black", "Good",

" No Comment"

)