Forum Discussion

steff131284's avatar
steff131284
Frequent Visitor
5 years ago
Solved

Reference to Sum Value

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...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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)