Forum Discussion

JosephS's avatar
JosephS
Regular Visitor
6 years ago
Solved

Join Against Unfiltered Column

I've got two tables, Sales and Targets, whose data I want to present in a report.  On the report I have a Line Chart presenting Sales by Territory.  I also have a Card with the Quarter Target.  Initi...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Perhaps:

     

     

    Measure =
  VAR __Territory = MAX('Sales'[Territory])
RETURN
  IF(HASONEVALUE('Sales'[Territory]),
    LOOKUPVALUE('Targets'[Target YoY%],'Targets'[Territory],__Territory]),
    MAXX(FILTER('Targets',ISBLANK('Targets'[Territory])),'Targets'[Target YoY%])
  )

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Perhaps:

 

 

Measure =
  VAR __Territory = MAX('Sales'[Territory])
RETURN
  IF(HASONEVALUE('Sales'[Territory]),
    LOOKUPVALUE('Targets'[Target YoY%],'Targets'[Territory],__Territory]),
    MAXX(FILTER('Targets',ISBLANK('Targets'[Territory])),'Targets'[Target YoY%])
  )

 

JosephS's avatar
JosephS
Regular Visitor
6 years ago

Thanks for responding.  I'm working on understanding and implementing your solution.  I'll let you know how it goes.