Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Insurance triangle

  I'm using a matrix to display a triangle.  The triangle is cumulative and currently extends to the maximum developmentperiodkey.   This is all well and good but I want it to blank /hide/not ...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    Try this

     

    Measure = CALCULATE([Value],FILTER(ALL('DevelopmentPeriods'),
    DevelopmentPeriods[DevelopmentPeriodKey]<=MAX(DevelopmentPeriods)))
*
DIVIDE([Value],[Value])
parry2k's avatar
parry2k
Super User
8 years ago

Anonymoussorry Im little lost here, I guess it will make sense if you can share sample data and how your tables are related.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Completely understand, I'm not making it very clear.

Its quite complex, I'm also using SSAS tab as the data source.

I'll see what I can do to Clarify.

Thanks again.