Formula stops working when filters are applied

[Anonymous]

Hello guys,

I don't understand why my formula stops being correct when filters are applied to my page.

Here is my formula:

Calcul Ratio Revenue =

if( OR(

        CONTAINS(Powerbi,Powerbi[Chart of Account V2],"ER"),

        CONTAINS(Powerbi,Powerbi[Chart of Account V2],"IR")

    ), "",

DIVIDE(

    CALCULATE(SUM(Powerbi[Amount Allocated]))

        ,

    CALCULATE(

            SUM(Powerbi[Amount Allocated]),

            ALLEXCEPT(powerbi, Powerbi[Product_9]),

            Powerbi[P&L indicator] = "Total Revenue"

        )

    ))

Maybe i have to add some code in it ?

Thanks in advance,

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try to change this pasrt of the code

CALCULATE (
    SUM ( Powerbi[Amount Allocated] ),
    ALLSELECTED ( powerbi ),
    VALUES ( Powerbi[Product_9] ),
    Powerbi[P&L indicator] = "Total Revenue"
)