Forum Discussion

rosscortb's avatar
rosscortb
Icon for Post Patron rankPost Patron
5 years ago
Solved

measure based on two tables

Hello, I would attach a sample but it's massive file so just try and explain what I'm trying to do. I have an employee table. ID Name Position Group( Director, Job Leader, Manager, Part Leader, ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    rosscortb You can use LOOKUPVALUE in a measure or a calculated column. Or a MAXX coupled with a FILTER.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

rosscortb You can use LOOKUPVALUE in a measure or a calculated column. Or a MAXX coupled with a FILTER.

  • rosscortb's avatar
    rosscortb
    Icon for Post Patron rankPost Patron
    5 years ago

    Greg_Deckler 

    Thanks Greg, so what can I add this to this that will make it only return values if there is a value in the position group column.  = 'Spans & Layers'[Position Group]

    Org Level = LOOKUPVALUE('Org Master Data'[Org. Level_1],'Org Master Data'[ObjectID],'Spans & Layers'[Org.unit])