Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I solved the 1st point above by creating a similar table to the 'Times Columns Table" above and then adding it to the measure calculation.

 

Sum X Quarters = 
VAR xQuarters = SELECTEDVALUE('Claim Development Quarters'[Claim Development])
VAR xDates = SELECTEDVALUE('Claim Occured Date'[Claim Occured Date])
VAR Result =
    CALCULATE(
        [Total sales],
        Triangle[TIME_UNITS_DELAY] <= xQuarters,
        Triangle[TIME_CLAIM_OCCURED] = xDates
    )
RETURN
    Result

 For the 2nd point some help would be grately appreciated 🙂