Filter on transactional level

Hi Anonymous ,

You should not create a relationship between the tables as you said. We can create a measure like this based on two slicers.

Group_Rate =
VAR a =
    MAX ( D_Time[Year] )
VAR b =
    MAX ( D_Time[MonthNo] )
RETURN
    CALCULATE (
        MAX ( Cons_Rates[Exc. Rate] );
        FILTER ( Cons_Rates; Cons_Rates[Year] = a && Cons_Rates[Month] = b )
    )

---

 

As you can see it comes with 1,20 for both companies..     so how do i get it so "relate"  without  creating a relation between the tables?    I have tried  adding a third filter    FILTER(Cons_Rate; 

---