Claim Frequency for Particular Year

Asfaa5 — Mon, 02 Mar 2020 03:01:31 GMT

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.

Re: Claim Frequency for Particular Year

Greg_Deckler — Mon, 02 Mar 2020 03:43:35 GMT

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