calculate the year average even when the drill down is monthly

[Anonymous]

Hello
I am trying to calculate the annual electricity expenditure target but I am only able to calculate monthly and not annually.
the annual target should be calculated by removing 3% of the value consumed in 2018. that is, in 2019 we subtract 3% in 2020 we subtract 6% ... and we divide this value by the number of pieces made.
after all this I do the average in the year the power bi is showing the value of 9.05 as the target for 2019 which is correct but when I drill down on the graph it shows me the monthly values and not a straight line with the value of 9.05.
I don't know if I managed to be clear.
please excuse my english. here's the simple ones from the file.
Thanks a lot for the help

[SQLbyoBI · Accepted solution]

---

@Anonymous wrote:

Hello
I am trying to calculate the annual electricity expenditure target but I am only able to calculate monthly and not annually.
the annual target should be calculated by removing 3% of the value consumed in 2018. that is, in 2019 we subtract 3% in 2020 we subtract 6% ... and we divide this value by the number of pieces made.
after all this I do the average in the year the power bi is showing the value of 9.05 as the target for 2019 which is correct but when I drill down on the graph it shows me the monthly values and not a straight line with the value of 9.05.
I don't know if I managed to be clear.
please excuse my english. here's the simple ones from the file.
Thanks a lot for the help

---

If you want to see the value for the year when you drill down to the month level, you could change your calc to...

objective v2 =
VAR __current_yr =
    SELECTEDVALUE(
        calender[Year],
        MAX( 'calender'[Year] )
    )
VAR __retval =
    AVERAGEX(
        CALCULATETABLE(
            ALL( 'calender'[Month] ),
            REMOVEFILTERS( 'calender' ),
            'calender'[Year] = __current_yr
        ),
        CALCULATE(
            'Measure'[AverageofaMeasure]
        )
    )
RETURN
    __retval

 ... but for this to work, you need to rebuild your table using the Month/Year columns from *your* date table (not the ones from the auto-generated date table...