Claim Frequency for Particular Year

[Asfaa5]

Hi Team,

I have Tables Claims with Column (Created Date, Status), Calendar Table for Date Measures.

Im trying to Calculate Claim Frequency for Particular Year = "2019",

Claims Frequency = Divide[Total Claims],[Total Sales] in Format %.

Now i need to calculate Claim Frequency of only "2019", which i need to use it as base and forecast for it for 2020.

Help me on this one to calculate Claim Frequency for Particular Year "2019" only.

[Greg_Deckler · Accepted solution]

Tought without sample source data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Perhaps:

Claims Frequency = 
  Divide(
    MAXX(FILTER('Table',[Year]=2019),[Total Claims],
    MAXX(FILTER('Table',[Year]=2019),[Total Sales]
  )