Forum Discussion

Arioli_Chezhian's avatar
Arioli_Chezhian
Helper II
3 years ago

DAX - Calculated column based on IF condition

Hi Team,
I have a scenario to achieve in DAX. The mentioned is the requirement.

 

The Training "T1" should be mapped only to Role 1. If other Role contains the T1 value it should be "Null". Other values in Training can be same. Only for T1 we need to achieve this. Even if data has 100 roles, if any role contains T1 value then it should be "Null" all other values are similar.

Please advice to achieve this output.

General Comments
Need Help
Tips and Tricks

1 Reply

  • AnthonyGenovese's avatar
    AnthonyGenovese
    Resolver III
    3 years ago

    I would do something like this for a caluclated column

     

    IF(AND('TableName'[Trainings]="T1", NOT('TableName'[Name]="Role 1")),BLANK(),'TableName'[Trainings])

     

    If this post was helpful, please kudos or accept the answer as a solution.
    ~ Anthony Genovese
    Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!