I can't remove a filter from a measurement

[victormarconis]

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"))

[Anonymous]

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.