Sales and Target mapping employee wise.

Question

Team,&nbsp;Kindly look into atatched document and advise.&nbsp;https://1drv.ms/w/s!AnNpoBzguZmmgdNCS5ac6q24cabUWA

v-chuncz-msft · Answer

unais&nbsp;
&nbsp;
You may try adding measures that apply virtual relationship in DAX.

unais · Answer

v-chuncz-msft&nbsp;&nbsp;kindly please advise below&nbsp; but no value&nbsp;target = CALCULATE(SUM(ZSD_SS_YT_DATA_EMP_TARG[TARGET]) ,TREATAS(SUMMARIZE('Calendar','Calendar'[Year],ZSD_SS_YT_DATA_EMP_TARG[TARGET]),ZSD_SS_YT_DATA_EMP_TARG[Year],ZVBRP_INV_LINT[SalesSpecialist]))

Forum Discussion

Sales and Target mapping employee wise.

2 Replies

Related content

Missing employee

Counting Active employees per month

Related employees via bridge

Counting number of employees meeting target when employee data

Varying Target By Employee and Month?