https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CODE-DAX/m-p/2719938#M82897 <P>hello everyone,</P><P>I have a problem with my data. Please help me</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>MISCODE</TD><TD>MISCODE_MANAGER</TD><TD>NOTE</TD><TD>KPI_PLAN</TD></TR><TR><TD>D001</TD><TD>D001</TD><TD>KPI</TD><TD>5</TD></TR><TR><TD>D002</TD><TD>D001</TD><TD>KPI</TD><TD>3</TD></TR><TR><TD>D003</TD><TD>D001</TD><TD>KPI</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Miscode D001 is manager of other Miscode (D002, D003). I want to build report for him (D001).&nbsp;</P><P>I use Card and Matrix to visulize data.&nbsp;</P><P>&nbsp; &nbsp; Matrix: D001 view all members of team =&gt; I have done</P><P>&nbsp; &nbsp; Card: D001 view only his KPI. But the value appears sum of all <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span> <FONT color="#FF00FF">i don't know how to code measure for this situation. Please help me</FONT></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thank</P> Tue, 23 Aug 2022 10:31:48 GMT KHOAND3 2022-08-23T10:31:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CODE-DAX/m-p/2719938#M82897 <P>hello everyone,</P><P>I have a problem with my data. Please help me</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>MISCODE</TD><TD>MISCODE_MANAGER</TD><TD>NOTE</TD><TD>KPI_PLAN</TD></TR><TR><TD>D001</TD><TD>D001</TD><TD>KPI</TD><TD>5</TD></TR><TR><TD>D002</TD><TD>D001</TD><TD>KPI</TD><TD>3</TD></TR><TR><TD>D003</TD><TD>D001</TD><TD>KPI</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Miscode D001 is manager of other Miscode (D002, D003). I want to build report for him (D001).&nbsp;</P><P>I use Card and Matrix to visulize data.&nbsp;</P><P>&nbsp; &nbsp; Matrix: D001 view all members of team =&gt; I have done</P><P>&nbsp; &nbsp; Card: D001 view only his KPI. But the value appears sum of all <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span> <FONT color="#FF00FF">i don't know how to code measure for this situation. Please help me</FONT></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thank</P> Tue, 23 Aug 2022 10:31:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CODE-DAX/m-p/2719938#M82897 KHOAND3 2022-08-23T10:31:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CODE-DAX/m-p/2720397#M82933 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="430934" data-lia-user-login="KHOAND3" class="lia-mention lia-mention-user">KHOAND3</a>&nbsp;</P> <P>Please refer to attched sample file withthe solution. However, it was not clear to me what do you need to do incase you have multiple managers.&nbsp;</P> <P><img /></P> <LI-CODE lang="javascript">Manager KPI = CALCULATE ( MAX ( Data[KPI_PLAN] ), TREATAS ( VALUES ( Data[MISCODE_MANAGER] ), Data[MISCODE] ) )</LI-CODE> Tue, 23 Aug 2022 13:20:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CODE-DAX/m-p/2720397#M82933 tamerj1 2022-08-23T13:20:37Z