Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
Anonymous
Not applicable

divide multiple column value single measure

i have a data like below  screen shot . i want show all multiple divide value in single visual

THENNA_41_0-1625435275893.png

 

i am trying to create a measure i am getting error 

 

shipement details = var Truck = SUM('Consumables'[01-Truck Sum of Spend])/SUM('Consumables'[01-Truck Sum of Sum of Shipement Per Quantity]) var STO=sum('Consumables'[02-STO Truck Spend])/SUM('Consumables'[02-STO Truck Sum of Sum of Shipement Per Quantity]) var STO=sum('Consumables'[02-STO Truck Spend])/SUM('Consumables'[02-STO Truck Sum of Sum of Shipement Per Quantity])
 
please any help . thanks in advance 
3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , based on what I got these are three different measures

 

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

 

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

 

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

 

If not what return statement you want. Var 2 and 3 was having same name

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

i am getting  unexpected expression error  like below screen shot 

 

THENNA_41_0-1625465854778.png

 

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.