DAX - Calculated column based on IF condition

[Arioli_Chezhian]

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.

[AnthonyGenovese]

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!