Need DAX correction

Hi PowerBIBeginer ,

First, let's look at nesting of IF functions. You have two IF functions in your expression, but there is no logical connection between them. This can result in calculations that are not as expected. You need to explicitly specify the relationship between the IF functions, for example, by using the ELSE keyword.

Second, you use the AND function in the first IF function, but you do not specify the relationship between the first and second conditions. You need to separate the two conditions with a comma, or use another logical operator (such as &&) to connect them.

Depending on your needs, you can try the following corrections:

Corrected DAX = 
VAR IsLost = 'SR'[Complex] = "LOST"
VAR ContainsTPA = CONTAINSSTRING('SR'[Holder], "TPA")

RETURN
IF(
    IsLost && ContainsTPA,
    CALCULATE(COUNT('SR'[ID])),
    IF(
        NOT ContainsTPA,
        CALCULATE(COUNT('SR'[ID]))
    )
)

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.