Forum Discussion

Arioli_Chezhian's avatar
3 years ago
Solved

Dynamic "IF" condition for calculated column

Hello everyone, I have a requirement to create a calculated column or Measure to achieve the below mentioned requirement. If Role 1 has the training T1 it should not be repeated for other Rol...
  • Ahmedx's avatar
    3 years ago

    pls try this

    Required Output = 
    VAR _rx = RANKX('Table',[Name],,ASC,Dense)
    VAR _Result = RANKX('Table',[Trainings],,ASC,Dense)
    RETURN
    IF(_Result=_rx,[Trainings])