Writing DAX for Slowly changing dimension Type 2 table

[vickyprudhvi]

Hi,

Below is the 2 tables

1) AdjusterHierarchy Table

2) ClaimRoot Table (fact). type 2

When we pull adjuster Field against 3PointDays total for ClaimRootEffectDateID as 09/03/2008

it should show details only or

ABC as 51

EDF as 60

But I am not able get that instead I am getting BCD as 29 too which is not right.

Kindly help pls