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

So for Custom $ Sales, I've created this measure to bring Sales from all my customers. There's just one source table for the Custom $ sales, and then sales of the total market is also it's own measure in the table. 


My retailer names come from table: 'Customers'[Store Names], Custom $ sales is 'Sales'[Custom $ Sales] and then Sales of the total market is from 'Sales'[Sales of the total market] 

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

Anonymous 
Please try

=
SUMX (
    VALUES ( 'Customers'[Store Names] ),
    DIVIDE (
        CALCULATE ( SUM ( 'Sales'[Custom $ Sales] ) ),
        CALCULATE ( SUM ( 'Sales'[Sales of the total market] ), ALL ( 'Customers' ) )
    ) * 100
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 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
      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
)