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