Ignoring drillthrough filter on a sheet

Andras E. 0
Viewed 21

I have a problem with a measure I'm currently working on.

I have 2 sheets, I drillthrough from sheet1 to sheet2 on column_A, but I also have synced slicers on both sheets for column_A that I use.

My measure needs to get all the selected values from column_A from sheet1, but when I'm on sheet2 I can only get the available values for the subgroup of column_A that I drilled through on or all the values using ALL()

Is there a way to get the original selection?

dax powerbi
1 Answers

There may be a more elegant solution, but you could filter the first page by a duplicate table, here Table2

enter image description here

and the main page

enter image description here

and the drilldown page with the measure

Measure = calculate( max('Table'[column_A]), REMOVEFILTERS('Table'), KEEPFILTERS(Table2))

enter image description here

David Browne - Microsoft0
Related