Forum Discussion

JaclynPugh2022's avatar
JaclynPugh2022
Icon for Helper II rankHelper II
3 years ago
Solved

Conditional Measure

Hi,   I have a calculated column 'PPO Open Conf and Rec'[Past or Future] that indicates Past or Future based on report name.  I am trying to create a conditional measure that calculates [STD PPV in...
Need Help
Tips and Tricks
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    3 years ago

    Use the DAX function IF. You can find the syntaxt and example here:
    https://dax.guide/if

    Measure=
    IF(
      SELECTEDVALUE('PPO Open Conf and Rec'[Past or Future]) = "Past",
      [STD PPV in ths],
      [PPV Forecast]
    )

Tutu_in_YYC's avatar
Tutu_in_YYC
Icon for Super User rankSuper User
3 years ago

Use the DAX function IF. You can find the syntaxt and example here:
https://dax.guide/if

Measure=
IF(
  SELECTEDVALUE('PPO Open Conf and Rec'[Past or Future]) = "Past",
  [STD PPV in ths],
  [PPV Forecast]
)