ignore filters but with valid row context

[jcamilo1985]

Good afternoon experts

I have the following data model, I need to perform a calculation in dax that allows me to bring the sales amount of the previous year to place it in a table, this calculation must ignore all user filters but must respect the filter context of the table is say show the amount for each row of the table "region", as you can see in the image I got a measure but ignore the context of the table row
Does anyone know how to achieve this effect

ventas año pasado =

var tot_ventas_full = SUMX(ALL(ventas),[ventas_pbs])

return

CALCULATE(tot_ventas_full,PARALLELPERIOD(calendario[keyDate],-1,YEAR))

[AllisonKennedy · Accepted solution]

You could either try using ALLEXCEPT or try putting specific tables in the ALL() to only ignore filters on some tables but not region.

Also, be careful with your SUMX function - you have put [Ventas_pbs] inside the SUMX and I'm guessing that [Ventas_pbs] is already a sum, so you're essentially asking Power BI to calculate a SUM of a SUM. This doesn't usually become apparent as an issue until you have unevenly spaced data, but it is NOT best practice to do a SUM inside a calculated column unless that is truly your intention (and I don't think it is in this case).