Power Bi Dax Help

[StefanoGrimaldi]

hey guysm I have this formula: 

.Saldo Ejecutado Indicadores / Saldo Ingresos =

DIVIDE(

    [.Saldo Ejecutado Indicadores],

    CALCULATE(

        [.Saldo Ejecutado Indicadores],

        ALL('Indicadores Financieros'[Indicador]),

        'Indicadores Financieros'[Categoria de cuenta] = "4. Ingresos"

    )

)

basically Im trying to make it ignore the filter given on a matrix visual when u add the row fields like the denominator only to be affected by the column but not the row filter. 

any help much appreciated. 

[PijushRoy · Accepted solution]

Hi @StefanoGrimaldi 

Please try below code

DIVIDE(
    [.Saldo Ejecutado Indicadores],
    CALCULATE(
        [.Saldo Ejecutado Indicadores],
        REMOVEFILTER('Indicadores Financieros'[Indicador]),
        'Indicadores Financieros'[Categoria de cuenta] = "4. Ingresos"
    )
)

If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

Thanks
Pijush

[StefanoGrimaldi]

nop, still same behaviour its dividing by the grand total as if its ignoring the column filter. 

[StefanoGrimaldi]

never mind it worked, need to change a column was using the wrong one, thanks 

[PijushRoy]

@StefanoGrimaldi 
You are welcome