Forum Discussion

StefanoGrimaldi's avatar
StefanoGrimaldi
Resident Rockstar
2 years ago
Solved

Power Bi Dax Help

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. 
Need Help
Show and Tell
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    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

4 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    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's avatar
      StefanoGrimaldi
      Resident Rockstar
      2 years ago

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

      • StefanoGrimaldi's avatar
        StefanoGrimaldi
        Resident Rockstar
        2 years ago

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