cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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])

3 REPLIES 3
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

Post Partisan

i am getting  unexpected expression error  like below screen shot

Super User

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors