Forum Discussion
Solved
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 =...
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] )
Greg_Deckler
Community Champion
Community ChampionTought 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]
)