Ignoring slicers using mutlple filter expressions in DAX measure

[Wilm117]

Hi Everybody,

I am struggling with a measure in which i want to ignore one of my slicers and for some reason i can't get it to work. I want to build two measures that show me a comparison between most recent report (latest ATB) and my previous report (2nd latest ATB). Through a RANKX column it is determined which report is the most recent and which is the previous one. In the example A below everything seems fine and it shows me the results i am looking for. However, when i start using my version slicer, it will not show my data from the previous report anymore (see example B). This also counts the other way around, when i select version 3 (previous version) it will not show the most recent value anymore.

example A

example B

The values in these tables come from the following measure:

2nd latest ATB = 
CALCULATE(
    SUM('ZPS11_totaal overzicht'[Bedrag]),
FILTER('ZPS11_totaal overzicht', 'ZPS11_totaal overzicht'[Post] = "ATB"),
FILTER('ZPS11_totaal overzicht', 'ZPS11_totaal overzicht'[NPO-WBS] = "NPO"),
FILTER('ZPS11_totaal overzicht', 'ZPS11_totaal overzicht'[RANK COLUMN] = 2))

Latest ATB = 
CALCULATE(
    SUM('ZPS11_totaal overzicht'[Bedrag]),
FILTER('ZPS11_totaal overzicht', 'ZPS11_totaal overzicht'[Post] = "ATB"),
FILTER('ZPS11_totaal overzicht', 'ZPS11_totaal overzicht'[NPO-WBS] = "NPO"),
FILTER('ZPS11_totaal overzicht', 'ZPS11_totaal overzicht'[RANK COLUMN] = 1))

I've also tried calculating  "2nd Latest ATB" as following:

2nd latest ATB = 
CALCULATE(
    SUM('ZPS11_totaal overzicht'[Bedrag]),
FILTER(ALL('ZPS11_totaal overzicht'), 'ZPS11_totaal overzicht'[Post] = "ATB"),
'ZPS11_totaal overzicht'[NPO-WBS] = "NPO" &&
'ZPS11_totaal overzicht'[RANK COLUMN] = 2)

This got me this result:

 I feel like i am close to my solution, but so far i couldn't figure it out exactly. 

Can anybody help me out?

[Anonymous]

I believe you should replace ALL with ALLSELECTED and reference your Version column in the ALLSELECTED statement.