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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
THENNA_41
Post Partisan
Post Partisan

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

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

i am getting  unexpected expression error  like below screen shot 

 

THENNA_41_0-1625465854778.png

 

@THENNA_41 , 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors
Top Kudoed Authors