need help

[faheem_Latif_BI]

I want to write a DAX for my conditional formatting, what is wrong with this .

Actual Spent Format = IF('Project Details'[state] = "closed" ) && CALCULATE(SUM('Project Details'[Custom_ActualSpentAmount]))=0
RETURN
"red"

Thanks 

[v-yangliu-msft]

Hi  @faheem_Latif_BI ,

Is your problem solved, if it is solved, you can mark the correct answer, if not, can provide detailed information, we can help you better.

Best Regards,

Liu Yang

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

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your desired outcome looks like, but please try the below whether it suits your requirement.

Actual Spent Format =
IF (
    SELECTEDVALUE ( 'Project Details'[state] ) = "closed"
        && SUM ( 'Project Details'[Custom_ActualSpentAmount] ) = 0,
    "red"
)