Forum Discussion

12Bowers12's avatar
12Bowers12
Helper V
7 years ago
Solved

TOTALYTD get empty

Good afternoon, everyone,

I have two measures to sum the premiums as below. When I try to summarize the premium on for each month, [Premium Written] gets the premium for each month. But [YTD Premium Written] gets blank result.

Any problem with the formula? Thank you.

Dennis

 

 

[Premium Written] =

CALCULATE(SUM(Policy[Premium]))

 

[YTD Premium Written] =

TOTALYTD ( [Premium], DateDimension[DateKey] )

Need Help
  • 12Bowers12's avatar
    12Bowers12
    7 years ago

    Thank you, I just figured it out.

    I should choose which year in VISUALIZATION FILTER to get YTD when using TOTALYTD. 

    Dennis

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    12Bowers12  - It looks fine, can you share your pbix on onedrive or dropbox?

  • edhans's avatar
    edhans
    Community Champion
    7 years ago

    Make sure the date in your visual is coming from your date table and not your Policy table.

    • 12Bowers12's avatar
      12Bowers12
      Helper V
      7 years ago

      Thank you, I just figured it out.

      I should choose which year in VISUALIZATION FILTER to get YTD when using TOTALYTD. 

      Dennis