Forum Discussion

ThomasSan's avatar
ThomasSan
Icon for Helper IV rankHelper IV
3 years ago
Solved

Table Filter not working when using measure

Hi everyone,   when I am using the following measure: LM Change = SWITCH( TRUE(), ISBLANK([LM CY]) && ISBLANK([LM PY]), blank(), DIVIDE( [LM CY], [LM PY], ...
DAX Divide Formula
Divide Function
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi  ThomasSan

    try like:

    LM Change =
    SWITCH(
        TRUE(),
        ISBLANK([LM CY]) && ISBLANK([LM PY]),
        0,
        DIVIDE(
            [LM CY],
            [LM PY],
            0
        )-1
    )

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi  ThomasSan

try like:

LM Change =
SWITCH(
    TRUE(),
    ISBLANK([LM CY]) && ISBLANK([LM PY]),
    0,
    DIVIDE(
        [LM CY],
        [LM PY],
        0
    )-1
)