Forum Discussion

AngelaB's avatar
AngelaB
Icon for Helper I rankHelper I
2 years ago

DAX command to differentiate between null value and zero in calculated column

Hello   **This post has been removed from Desktop thread and reposted here as I think may be more appropriate**   I've read a few posts along these lines and tried a few of the solutions but none...
DallasBaba's avatar
DallasBaba
Icon for Skilled Sharer rankSkilled Sharer
2 years ago

AngelaB you can  modify the furmula

[calculated%] =
VAR defined_var =
    DIVIDE(
        CALCULATE(
            COUNTA([Value A]),
            [Value A] IN { "Yes" }
        ),
        COUNTA([Value A])
    )
RETURN
    IF(
        ISBLANK(defined_var),
        "Null",
        IF(
            defined_var = 0,
            "0%",
            defined_var
        )
    )

This formula should allow you to distinguish between null and 0% values in your [calculated%] column

 

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

 

  • AngelaB's avatar
    AngelaB
    Icon for Helper I rankHelper I
    2 years ago

    Thanks again, but same result I'm afraid, blank and 0 all return "null".