See data used in a cumulative

[Salah_Guigui]

Hi all, hope you are doing well.

I have a little problem.       
                                                              Cumulative

                       sum1         sum2          SUM1       SUM2

 i have those measures that relate to a specific mouth and year (N) and the previous year (N-1).

Like : in a slicer i chose Year = 2021; month = MAY

sum1 = sum(column1)	sum2 = sum(column2)	SUM1 = cumulative of sum1 for the previous months of the same year	SUM2 = cumulative of sum2 for the previous months of the same year
same of above but previous year	same of above but previous year	same of above but previous year	same of abouve but previos year

         I created a button above those cards so when I click in it, I can see, in another page, the data used for those measure. 

The problem is when I click in SUM1 or any other card (cumulative or previous year); I only see the data filtered by the slicer (like the data for MAY2021 and not the data of the previous month) 

What i see when i click like an exemple for SUM1 to see cumulative informations

Column 1	Year	month	Agence
the sum = sum 1	2020	5	X

And what i wanna see 

Column 1	Year	month	Agence
Value 1	2020	5	X
Value 2	2020	5	X
Value 3	2020	4	X

I hope it's clear, and that you help me find a solution 🙂 

[lbendlin]

"I created a button above those cards so when I click in it, I can see, in another page, the data used for those measure. "

You may want to consider using Drillthrough instead.  In either case you will have to re-apply your measures in the target page.

[Salah_Guigui]

Hi, thanks for your answer, 

I used the Drillthrouph, but the slicer affects the result so same problem and same result.