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
)

6 Replies

  • 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



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

    Hi Anonymous 

    What do have on the rows of your table/matrix visual? How many source data tables are involved in the two measures? what is the dax for both measures?

    • 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
)