https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Writing-DAX-for-Slowly-changing-dimension-Type-2-table/m-p/24621#M156405 <P>Hi,</P><P>Below is the 2 tables</P><P>1) AdjusterHierarchy Table</P><P>2) ClaimRoot Table (fact). type 2</P><P>&nbsp;</P><P>When we pull adjuster Field against 3PointDays total for&nbsp;ClaimRootEffectDateID as <STRONG>09/03/2008</STRONG></P><P>it should show details only or</P><P>ABC as 51</P><P>EDF as 60</P><P>But I am not able get that instead I am getting BCD as 29 too which is not right.</P><P>Kindly help pls</P><P>&nbsp;<img /></P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline"><SPAN class="lia-message-image-wrapper"><SPAN class="lia-messages-message-image ng-scope">&nbsp;<!-- ngIf: link --> </SPAN></SPAN></SPAN></P> Thu, 24 Mar 2016 12:43:26 GMT vickyprudhvi 2016-03-24T12:43:26Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Writing-DAX-for-Slowly-changing-dimension-Type-2-table/m-p/24621#M156405 <P>Hi,</P><P>Below is the 2 tables</P><P>1) AdjusterHierarchy Table</P><P>2) ClaimRoot Table (fact). type 2</P><P>&nbsp;</P><P>When we pull adjuster Field against 3PointDays total for&nbsp;ClaimRootEffectDateID as <STRONG>09/03/2008</STRONG></P><P>it should show details only or</P><P>ABC as 51</P><P>EDF as 60</P><P>But I am not able get that instead I am getting BCD as 29 too which is not right.</P><P>Kindly help pls</P><P>&nbsp;<img /></P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline"><SPAN class="lia-message-image-wrapper"><SPAN class="lia-messages-message-image ng-scope">&nbsp;<!-- ngIf: link --> </SPAN></SPAN></SPAN></P> Thu, 24 Mar 2016 12:43:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Writing-DAX-for-Slowly-changing-dimension-Type-2-table/m-p/24621#M156405 vickyprudhvi 2016-03-24T12:43:26Z