Forum Discussion

faheem_Latif_BI's avatar
faheem_Latif_BI
Icon for Helper I rankHelper 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"
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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"
)