Need Help with sum Totals and calculate objetive with Matrix Visual.
Hello everibody. wishing you and your family are good and healthy, i want to know if some of you could help me with my necesity. right now i need to stash some time objetives on customer visits and i want to have this dynamics. My Code today is: Objetivos de Visita = VAR IMT = SELECTEDVALUE(BU[BG Fix])="IQS" RETURN VAR MED=SELECTEDVALUE(BU[BG Fix])="MED" RETURN VAR MIC = SELECTEDVALUE(BU[BG Fix])="RMS" RETURN VAR ObjetivoMes = HASONEFILTER('End_Date'[FiscalYear]) && HASONEFILTER(End_Date[FiscalQuarter]) && HASONEFILTER(End_Date[MonthName]) RETURN VAR ObjetivoQ = HASONEFILTER('End_Date'[FiscalYear]) && HASONEFILTER(End_Date[FiscalQuarter]) RETURN VAR ObjetivoFY = HASONEFILTER('End_Date'[FiscalYear]) RETURN IF(IMT && ObjetivoMes,32,IF(IMT && ObjetivoQ,96, IF(IMT && ObjetivoFY,384,IF(MED && ObjetivoMes,80, IF(MED && ObjetivoQ, 240, IF(MED&&ObjetivoFY, 960,if(MIC&&ObjetivoMes,80,if(MIC&&ObjetivoQ,240, IF(MIC&&ObjetivoFY,960,960))))))))) and the result is: but i want to have the actual target respect with the day of the year or day of the month or day of the Q, use fixed just when we need to see the past. also i want to have the correct total of the sum in the objetiv in Matrix Visual. i will really apreciate your help and support.
