THE SYNTAX FOR ) IS INCORRECT

[Anonymous]

 I have  following measure like 

1. Shipment valueslist =
2. Var Truck = divide(SUM('Consumables'[01-Truck Sum of Spend]),SUM('Consumables'[01-Truck Sum of Sum of Shipement Per Quantity]))
3. var STO= divide(sum('Consumables'[02-STO Truck Spend]) , SUM('Consumables'[02-STO Truck Sum of Sum of Shipement Per Quantity]) )
4. var SEA = divide(sum('Consumables'[04-Sea - Sum of Spend]), SUM('Consumables'[04-Sea - Sum of Sum of Total Qty]))
5. var AIR=DIVIDE(sum(Consumables[05-Air - Sum of Spend]),sum(Consumables[05.Air - Sum of Sum of Total Qty]))

i  getting error  THE SYNTAX FOR ) IS INCORRECT also i want retrun all value. i want to show all value single visual .any help 

[nandukrishnavs]

@Anonymous 

In your measure, the return value was missing. If you are trying to show the result on the card visual you can try the below measure.

Shipment valueslist =
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 _result = "Trunk :" & _Trunk & ", STO :" & _STO & ", SEA :" & _SEA & ", AIR:" & _AIR
RETURN
    _result

[Anonymous]

www.daxformatter.com