I have created a report with data slicers from (date) to (date)
While creating them one of its visualizations is a gauge and it shows total sales until last dates from early target.
This model has a target table namely monthly target, dimdatestable and sales table.
In order to use an yearly target I have created this DAX measure:
yearly_target = CALCULATE(SUMX(Targests,'Targests'[Target $]),ALLEXCEPT(dimDate,'dimDate'[year]))
I am not sue if the DAX solution is appropriate for the following data