How to create a measure using Divide from the same column where one row is num and other as denom

[rampsaladi]

Hi All,

I need to divide the value from one row as the denominator and the numerator as different rows of the same column. I would like to know how to do this in DAX. Below is the DAX

Product     $      $ Share

Prod 1      100     Expected Value 100/100 = 1

Prod 2        60      60/100  = 0.6

Prod 3        40      40/100  =  0.4

Need to Know how to calculate the $ Share value and this value can change based on the time period and customer selected.

Any help would greatly be appreciated

[Ashish_Mathur]

Hi @rampsaladi,

Do not write that formula in a column.  Write it as a measure

Total=SUM(Data[Amount])

Share (%) = [Total]/CALCULATE([Total],ALL(Data[Product]))

Hope this helps.

[Greg_Deckler · Accepted solution]

Perhaps a calculated column like:

$ Share = [$] / MAX([$])

?