Forum Discussion

Trist's avatar
Trist
Frequent Visitor
5 years ago

IF Issue in Measure

Hello Everybody, how are you?  ı have question about writing a row context dax in a ıf clause .  ı want to wrıte this query(*1) ınsıde of this query(*2). how to do that do u think?   *1:   IF   ...
Need Help
Need Info
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

SWITCH will work. You shouldn't name your measure VALUES - that is a function in DAX. Call it something else. 

 

New Measure =
IF(
    ISBLANK( [Day] ),
    BLANK(),
    SWITCH(
        TRUE(),
        A[X] = "H",
            A[Y] * A[Z] * ( -1 ),
        A[X,] = "S",
            A[Y] * A[Z],
        0
    )
)