Reference to Sum Value

[steff131284]

Hi,

quick question.

I have a data set with different "Delta" positions and one total output. 

I now want to reference each of the variance categories to the total output. In Excel this would be easy by using the $ sign.

How do I need to change my formular?
Right now it is 

Delta MA Quote = [Delta MA in €]/[Gesamtleistung Ist]    but this only works for the Total and not the single categories?

Best regards

Stefan

[Fowmy · Accepted solution]

@steff131284 

Modify the formula to one of these:

Delta MA Quote = 
DIVIDE (
    [Delta MA in €],
    CALCULATE (
        [Gesamtleistung Ist],
        ALLSELECTED ( Table[Variance])
    )
) 

Delta MA Quote = 
DIVIDE (
    [Delta MA in €],
    CALCULATE (
        [Gesamtleistung Ist],
        ALLSELECTED ()
    )
) 

[amitchandak]

@steff131284 , Not very cleat. It is working. but you do not have value for Gesamtleistung Ist

better version

Delta MA Quote = divide( [Delta MA in €],[Gesamtleistung Ist])

or

Delta MA Quote = divide( [Delta MA in €],[Gesamtleistung Ist],0)