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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

table name cannot used to define a variable

 i have a created multiple divide  function  in measure . finally trying to return all divide  variable  functions single measure 

 

shipment value =
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 SEA =
DIVIDE (
SUM ( 'Consumables'[04-Sea - Sum of Spend] ),
SUM ( 'Consumables'[04-Sea - Sum of Sum of Total Qty] )
)
VAR AIR =
DIVIDE (
SUM ( 'Consumables'[05-Air - Sum of Spend] ),
SUM ( 'Consumables'[05.Air - Sum of Sum of Total Qty] )
)
VAR MarginPerc =Truck, SEA, AIR, STO 
RETURN
MarginPerc
 
but i am getting Error  'Truck' is a table name and cannot be used to define a variable. any  idea   thanks in advance 
1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , You can not return 4 values. There need to some operation between them

 

VAR MarginPerc =Truck & SEA & AIR & STO  //appending all
RETURN
MarginPerc

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.