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

Can you share the screen shot what you put in filter for relative date filter?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I'm trying to simplify things with the example data.

The Relative filter I've just created uses the Accounting Period Start Date.

This is because there are no dates in the development periods table.

Each Value havs a development period derived from the Accounting period of the transaction:

 

Thank you 

 

 

  • 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.