The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
plse try this
level-FDunit =
VAR _t1 = 'incentive_cal[Employee Id]
RETURN
CALCULATE(
(IF([FDunitcurrent_mnth]>=3,l,
IF([FDunitcurrent_mnth]>=5,2,3))),
FILTER (ALL(incentive_cal),incentive_cal[Employee Id]=_t1))