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
year |
yearly_target |
total sales |
2018 |
5,780,575 |
67,025 |
Total |
10,330,575 |
366,025 |