Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Divide each value in a column by another value

123
  • tamerj1's avatar
    tamerj1
    3 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
3 years ago

hello Anonymous ,
you can use the following:

Your measure = (SUM(table[Custom Sales]) / CALCULATE(SUM(table[Custom Sales]),ALL(table)))) * 100