Forum Discussion
Filter on transactional level
Faily new to DAX. So maybe my approach isn't to most straight way forward. If so please feel free to suggest another approach. I'm trying to build a consolidation tool. To consolidate P/L based ...
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;
Thanks for the effort.
Unfortunatly it's still returning the same result for both companies. Like in the example show in OP.
It seems to be missing the final filter link.. Something like Filter(Cons_rates; Cons_Rates[Company] = F_FinanceTransactions[Company] ) So it will return 1.2 for the UK company, but 1 for the US company.
I found the error.. your solution worked.. thanks