Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

divide multiple column value single measure

i have a data like below  screen shot . i want show all multiple divide value in single visual   i am trying to create a measure i am getting error    shipement details = var Truck = SUM('...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

i am getting  unexpected expression error  like below screen shot 

 

 

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , In one measure, try  like

measure =

Var  Truck = divide(SUM('Consumables'[01-Truck Sum of Spend]),SUM('Consumables'[01-Truck Sum of Sum of Shipement Per Quantity]))

 

var  STO= divide(sum('Consumables'[02-STO Truck Spend]) , SUM('Consumables'[02-STO Truck Sum of Sum of Shipement Per Quantity]) )

 

var STO1 = divide(sum('Consumables'[02-STO Truck Spend]), SUM('Consumables'[02-STO Truck Sum of Sum of Shipement Per Quantity]))

 

return

<write the return you want >