Need some help for a fixed denominator

[Anonymous]

Hello,

I am new at using powerbi and I am facing an issue.

My table is "Powerbi"

I want to divide each elements of my lines in my matrix from Powerbi[Chart of Account V2] by a fixed denominator.

The division will be for each elements of my lines: 

SUM(Powerbi[Amount Allocated]) for an element of Powerbi[Chart of Account V2] / fixed SUM(Powerbi[Amount Allocated]) filtered by Powerbi[Indicator] = "Total Revenue".

I tried this but it does not seem to work :

DIVIDE(

        CALCULATE(

            SUM(Powerbi[Amount Allocated])

        ),

        CALCULATE(

            SUM(Powerbi[Amount Allocated]),

            ALLEXCEPT(powerbi, Powerbi[Product_9]),

            Powerbi[Indicator] = "Total Revenue"

        )

    ))

Could someone help me on this ? 

Kind regards

[some_bih · Accepted solution]

Hi @Anonymous for an element of Powerbi[Chart of Account V2]  - this part was not in your formula, try below

DIVIDE (
SUM ( Powerbi[Amount Allocated] ),
CALCULATE (
SUM ( Powerbi[Amount Allocated] ),
ALLEXCEPT ( Powerbi, Powerbi[Chart of Account V2] ),
Powerbi[Indicator] = "Total Revenue"
)
)

Did I answer your question? Mark my post as a solution! Kudos Appreciated!