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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. 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

Share with Power BI Enthusiasts: 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 >

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.