Forum Discussion

KHOAND3's avatar
KHOAND3
New Member
4 years ago

CODE DAX

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...
tamerj1's avatar
tamerj1
Community Champion
4 years ago

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] )
)