table name cannot used to define a variable

Anonymous — Tue, 06 Jul 2021 15:20:53 GMT

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

Re: table name cannot used to define a variable

amitchandak — Tue, 06 Jul 2021 15:31:31 GMT

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

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