Using LOOKUPVALUE with multiple values matching criteria

[Anonymous]

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?

[Anonymous]

create a relationship between Table1 and Table2 using Zisson_id

Then,

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

[Anonymous]

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.