Drill though Cumulative totals/percentages incorrect on Triangle

[mrmikenz]

Hi Everyone, first post so be kind.

Im relatively new to Power BI/DAX so this may be a simple solution (i hope so anyway)

I have created a Loss Ratio Triangle (Matrix) which is working fine. it is split by Year Created and the number of years since it was created. which is based on the cumulative totals throughout the age of a file

I have also created a Drill though page in the hopes of detailing the numbers that contirbute to the total.

The total is cumulative and takes into account all of the previous years.

if you look at a cell (eg Year:2005, Age:6 )  you see that the Loss is 22.16% but if you drill through on the cell it displays

The Drill through only shows Age 6 which obviously incorrect it needs to be <=6

i.e.

You can fix is by changing the filter from Age = 6 to Age <= 6 but i was hoping there was a way of having it done automatically

 if it helps the cumulative total calculation is as follows:

Any help/ advice anyone could give would be greatly appreciated!

[v-yuta-msft · Accepted solution]

Hi mrmikenz,

Based on your requirement, to achieve your requirement, you can create a slicer visual or create a visual level filter instead of "drillthrough".

Regards,

Jimmy Tao