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

AnonymousI'm glad it worked out, I love PowerBI community. Feel free to reach out for any future questions. Cheers!!!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks again for the answer, however since nothing is straight forward I have a slight problem with the solution.

 

Below is a slightly different example, where the value (In Orange) has not changed in a period so the Cumulative Values stays the same.

These values are now (on the right) understandably blank, is there any way to prevent this from happening until we reach the Current Months Development period?

 

Many thanks in advance

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    Please use relative date filter and remove divide calculation with total

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks, tried that, but now values contine to end of development periods as before:

      Running Total = 
CALCULATE([Value],FILTER(ALL('DevelopmentPeriods'),DevelopmentPeriods[DevelopmentPeriodKey]<=MAX(DevelopmentPeriods[DevelopmentPeriodKey])))

      Is there a way to restrict what they develop to by a dynamic date.

      I believe The ALL() Filter set this to all periods?

       

       

      Thanks again!

      • parry2k's avatar
        parry2k
        Super User
        8 years ago

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