Forum Discussion
Claim triangles in PowerBI
Hello Community, I am trying to build some claim triangles in PowerBI. I won't bore you with the details as I have one specific question for the matrix visual. I have data in the following fo...
Hi Anonymous ,
I'm not sure but you can try this:
Sum X Quarters =
VAR xQuarters = SELECTEDVALUE('Claim Development Quarters'[Claim Development])
VAR xDates = SELECTEDVALUE('Claim Occured Date'[Claim Occured Date])
VAR Result =
CALCULATE(
sum(Table[Total sales]),
Triangle[TIME_UNITS_DELAY] <= xQuarters,
Triangle[TIME_CLAIM_OCCURED] = xDates
)
RETURN
IF(selectedvalue('Table'[reporting date]<= xDates, Result,0)
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous thank you for the effort. This added condition makes no change. In the time of your proposal I was writing a more clear comment for my issue: https://community.powerbi.com/t5/Desktop/Calculate-cummulative-value-until-condition/m-p/2715925 Hope this is more clear.