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('...
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

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