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])
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Incredible... thank you so much for the solution and amazingly quick response!!??

You don't know how long I'm spent looking at this.

Very much obliged.

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!