topic Re: CANT REMOVER FILTERS FROM A MEASURE in DAX Commands and Tips

CANT REMOVER FILTERS FROM A MEASURE

Anonymous — Tue, 18 Jun 2024 12:11:29 GMT

Hello guys, I am a trouble with my measure , I simply can't get the value of the whole period using the function ALL, because even if I use it, when I filter the slicer, it keeps filtering the date. How Can I solve this?

This measure brings me the value of stock, based on the last sequence of all products, different stocks and companies.

03M - Estoque Total =
VAR UltimasSequencias =
SUMMARIZE(
'fEstoque Lancamento',
'fEstoque Lancamento'[Cod Empresa],
'fEstoque Lancamento'[Cod Almoxarifado],
'fEstoque Lancamento'[Cod Produto],
"UltimoSeq", MAX('fEstoque Lancamento'[Nr Sequencia])
)

VAR EstoqueTotal =
SUMX(
UltimasSequencias,
VAR CodEmpresa = [Cod Empresa]
VAR CodAlmoxarifado = [Cod Almoxarifado]
VAR CodProduto = [Cod Produto]
VAR UltimaSequencia = [UltimoSeq]
RETURN
CALCULATE(
MAX('fEstoque Lancamento'[Qtd Total]),
'fEstoque Lancamento'[Cod Empresa] = CodEmpresa,
'fEstoque Lancamento'[Cod Almoxarifado] = CodAlmoxarifado,
'fEstoque Lancamento'[Cod Produto] = CodProduto,
'fEstoque Lancamento'[Nr Sequencia] = UltimaSequencia,
ALL('fCalendário'[Date]) --- I TRIED USING ALL, ALLEXCEPT, REMOVEFILTERS, BUT NOTHING HAS CHANGED.
)
)

RETURN EstoqueTotal

Re: CANT REMOVER FILTERS FROM A MEASURE

rajendraongole1 — Tue, 18 Jun 2024 14:09:11 GMT

Hi Anonymous - The issue arises because filter with removal functions are being applied inside the calculate statement, which might not remove filters,

Can you try the below measure

RETURN EstoqueTotal

I think it works changes mentioned in highlighted color

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Re: CANT REMOVER FILTERS FROM A MEASURE

Anonymous — Tue, 18 Jun 2024 14:27:31 GMT

hEY rajendraongole1 , thanks for your support, but still didnt work. How can I share my file here?

Re: CANT REMOVER FILTERS FROM A MEASURE

Anonymous — Thu, 20 Jun 2024 02:04:07 GMT

Hi Anonymous,

You can create some dummy data and paste to your thread with table format or upload the sample data to a network driver and share the link here.

Notice: remove sensitive data before share.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng