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 total of 2023 that keeps updating as the year goes on.
 
And a previous total of 2022. 
  • 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
    )

4 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    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)
        )