filter in total matriz

[Anonymous]

hello i would like to know if you can put a filter in the total column of a matrix but without losing the filters that I’m already using in the same

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

so to improve understanding, I have a matrix table with values ​​per month and these values ​​I’m putting a filter on them because when it’s from January to November he has to get an X filter when it’s December he gets the Y filter and when is the total of the matrix he would take the Z filter

metric:

VAR SELECAOVISAO = SELECTEDVALUE(D_CALENDARIO[Mês])

RETURN(

    CALCULATE(

        (

SUM(F_SaldoPorContaMes_CQ0010[CQ0_DEBITO]) -

SUM(F_SaldoPorContaMes_CQ0010[CQ0_CREDIT])) *-1,

IF(

SELECAOVISAO = "Dezembro",

F_SaldoPorContaMes_CQ0010[CQ0_LP] = "S",

F_SaldoPorContaMes_CQ0010[CQ0_LP] = "N"),

in the case when it is December he takes S and when it is the other months he takes N until then ok, so the visual of the power bi matrix makes an automatic sum at the end of the graph and when he makes this sum he has to get the type Z, but it is the sum that the graph itself makes