Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Icon for Helper V rankHelper V
5 years ago
Solved

Create a relationship with DAX

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?

 

Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    CarlsBerg999,

     

    Try this measure:

     

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

     

1 Reply

  • DataInsights's avatar
    DataInsights
    Icon for Super User rankSuper User
    5 years ago

    CarlsBerg999,

     

    Try this measure:

     

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