FILTER( 'Estoque_Diario_502_Filial_1', [DATA] = [DataEstoqAnt502_Filial1])) where DataEstoqAnt402_Filial1 is a dax formula that returns the last date that had movement. , but the formula is returning the wrong value.
In principal what you're trying to do is fine. I suspect the reason you're getting wrong values is that your measure
is being evaluated in the context of each row in your filter table (measures force a
context transition.) Depending on what result you're trying to achieve you want to read the value into a variable earlier on to fix it. As @PijushRoy suggests can you share a sanitised pbix file?
