Year Total

[amandabus21]

How can I get a year total of my meausre.  As in I always want the whole total of the current year.

Measure is =Accidents Per 100K Miles

Date: 

'Datamart AccidentSummary'[Merged FC])

So a total of 2023 that keeps updating as the year goes on.

And a previous total of 2022. 

[amandabus21]

nevermind had the wrong filters!

[FreemanZ · Accepted solution]

hi @amandabus21 

try like:

YearTotal=

CALCULATE(

    [Accidents Per 100K Miles],

    YEAR('Datamart AccidentSummary'[Merged FC])=YEAR(TODAY())

)

LasrYearTotal=

CALCULATE(

[Accidents Per 100K Miles],

YEAR('Datamart AccidentSummary'[Merged FC])=YEAR(TODAY())-1

)

[amandabus21]

Hi ,

First measure: 

this gives me total of last month.  (Dec = .91)

I need whole year  (1.07)

[FreemanZ]

aha, then try like:

YearTotal=

CALCULATE(

    [Accidents Per 100K Miles],

    FILTER(

        ALL('Datamart AccidentSummary'),

    YEAR('Datamart AccidentSummary'[Merged FC])=YEAR(TODAY()))

)

LasrYearTotal=

CALCULATE(

[Accidents Per 100K Miles],

FILTER(

        ALL('Datamart AccidentSummary'),

YEAR('Datamart AccidentSummary'[Merged FC])=YEAR(TODAY())-1)

)