Create a relationship with DAX

[CarlsBerg999]

Hi,

I have data that is incomplete. I have a matrix table in Power BI, where i want to add information to a specific person. I don't want to create another table etc. and then join these together. What i need is a DAX measure, that adds 100 to Sales Person 6. 

What I've tried so far is this:

=CALCULATE(
(100),
TREATAS({"Sales person 6",Sales[Sales personnel]))

This however doesn't work. I need to relate the 100 to the sales person 6 but this doesnt relate correctly. Any ideas?

[DataInsights · Accepted solution]

@CarlsBerg999,

Try this measure:

Total Sales =
IF (
    MAX ( Sales[Sales personnel] ) = "Sales person 6",
    SUM ( Sales[Sales amount] ) + 100,
    SUM ( Sales[Sales amount] )
)