Forum Discussion
Claim Frequency for Particular Year
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.
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] )
1 Reply
- Greg_Deckler
Community Champion
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] )