Create a cumulative claim count measure based on claim count measure

[Anonymous]

I want to create loss triangle table, where it should be cumulative. I have figured out the formula and table, but the value is not cumulative

This is my formula for claim count:
Claim Count = CALCULATE(COUNT(Claim[Reg.date]))

when i try to create for cumulative, it gonna sum the value for the previous period too, how do i solve this issue ?

Thank you in advance for yr help 😄 

[rubayatyasmin]

Hi, @Anonymous 

try: 

Cumulative Claim Count =
CALCULATE (
COUNT ( Claim[Reg.date] ),
FILTER (
ALL ( Claim ),
Claim[Reg.date] <= MAX ( Claim[Reg.date] )
)
)

similar thread: How to Calculate Cumulative Values with DAX - Microsoft Fabric Community

[Anonymous]

Hi @rubayatyasmin , i have applied this but maybe due to complexity in my data, i can't solve it. but i have found another way, which is by clicking "New Quick Measure", where it gives me a lot of option to calculate (sum, average, product etc.) by rearrange the data and field. Thank you for your reply 😄 

[Anonymous]

Claim Count = 
var a= max([claim count])
Return
CALCULATE(COUNT(Claim[Reg.date]), filter(all(YourTablename),[claim count]=a)

Hi Try the abo ve dax