Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Using LOOKUPVALUE with multiple values matching criteria

Hi,

Im having hard time finding a workaround to this

 

I have two tables:

I want to sum the total "Timeuse pause" field by hour intervals in table 1,   but only for the "Zisson id's" that has been logged on certain queue (queue id= 3) on "table 2"

 

Table 1

 

 

Table 2

 

 

Relationship are:

 

 

I was suggested to use LOOKUPVALUE,  but as I might have several matches (Same "Zisson Ids" logged on diffrent "Queue_Ids" on the sma hour interval,  I do not get the DAX to work they I expected.

 

 

 

Any suggestions?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    create a relationship between Table1 and Table2 using Zisson_id

    Then,

    Measure = CALCULATE(SUM(Table1[Timeuse pause],FILTER(Table2, Table2[Queue_Id] = 3)))

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks nikhilmekala,

       

      not sure if that will work since it would be a many to many relationship. I have no primary keys in neither tables. That’s why I am using that Empl_Lookup table that has single values for Zisson_id field to relate both.