Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Divide each value in a column by another value

123
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 
    So again.. it's a measure. Please try

    =
SUMX (
    VALUES ( 'Customers'[Store Names] ),
    DIVIDE (
        [Custom $ Sales],
        CALCULATE ( [Sales of the total market], ALL ( 'Customers' ) )
    ) * 100
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey! I tried this, but for the 'Sales'[Custom $ Sales] it says they're not the right parameter... I created these measures within 'Sales' 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 
So again.. it's a measure. Please try

=
SUMX (
    VALUES ( 'Customers'[Store Names] ),
    DIVIDE (
        [Custom $ Sales],
        CALCULATE ( [Sales of the total market], ALL ( 'Customers' ) )
    ) * 100
)