Forum Discussion

faheem_Latif_BI's avatar
faheem_Latif_BI
Helper I
3 years ago
Solved

need help

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 

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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"
)

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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"
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.