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 ()
    )
)
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
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 ()
    )
)