Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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])
 
please any help . thanks in advance 

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      i am getting  unexpected expression error  like below screen shot 

       

       

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        Anonymous , 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 >