Divide each value in a column by another value

[Anonymous]

123

[tamerj1]

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]

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]

@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]

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 · Accepted solution]

@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]

hello @Anonymous ,
you can use the following:

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