CODE DAX

[KHOAND3]

hello everyone,

I have a problem with my data. Please help me

MISCODE	MISCODE_MANAGER	NOTE	KPI_PLAN
D001	D001	KPI	5
D002	D001	KPI	3
D003	D001	KPI	2

Miscode D001 is manager of other Miscode (D002, D003). I want to build report for him (D001). 

I use Card and Matrix to visulize data. 

    Matrix: D001 view all members of team => I have done

    Card: D001 view only his KPI. But the value appears sum of all 😞 i don't know how to code measure for this situation. Please help me

Thank

[tamerj1]

Hi @KHOAND3 

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. 

Manager KPI = 
CALCULATE ( 
    MAX ( Data[KPI_PLAN] ),
    TREATAS ( VALUES ( Data[MISCODE_MANAGER] ), Data[MISCODE] )
)