Forum Discussion

amandabus21's avatar
amandabus21
Helper V
3 years ago
Solved

Year Total

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 ...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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's avatar
amandabus21
Helper V
3 years ago

Hi ,

First measure: 

 

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

 

I need whole year  (1.07)

 

 

FreemanZ's avatar
FreemanZ
Super User
3 years ago

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)
)