I can't remove a filter from a measurement

victormarconis — Fri, 11 Aug 2023 16:53:46 GMT

I have a matrix, I have a product and below are the branches. I have the stock column, it looks perfect and I have a product demand column. When I do a cross filter with a table on the side, in this matrix, it filters the product (so far so good), but the stock column remains and the demand is filtered only by the branch of the clicked product.

What I don't understand is why the stock one doesn't filter and the demand one does.

I need you not to filter the branch in this demand, below I will send the measure of the demand and a print of the columns. Inventory column is just sum(column).

demandmonth =

VAR _valorlinha = CALCULATE(MAX(entradas[demandames]))

VAR _valormatriz = CALCULATE(SUMX(VALUES(entradas[demandames]), CALCULATE(MAX(entradas[demandames]))))

VAR _contexto = ISINSCOPE('apresentaçao'[apresentacao])

VAR _contexto2 = ISINSCOPE(filial[nome])

VAR _contexto3 = ISINSCOPE(produto[produtofab])

RETURN

CALCULATE(SWITCH(

TRUE,

_contexto2, _valormatriz,

_contexto3, _valorlinha,

_contexto, _valormatriz,

"Outro"))

Re: I can't remove a filter from a measurement

Anonymous — Mon, 14 Aug 2023 02:08:07 GMT

Hi victormarconis ,

Please try to use REMOVEFILTERS() function, it will clear filters from the specified tables or columns.

For more details, you can read related document: REMOVEFILTERS function (DAX) - DAX | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic I can't remove a filter from a measurement in DAX Commands and Tips

I can't remove a filter from a measurement

Re: I can't remove a filter from a measurement