Forum Discussion

onkelphill's avatar
onkelphill
Frequent Visitor
8 years ago

Calculate Total Price | Lookup values

Hello everyone,   looking for help to solve with the following, probably standard, scenario.   I need to calculate the total price ( quantity * rate) for each transaction of the Lanes table. Ulti...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

onkelphill,

 

You may consider using RANKX Function to add a calculated column first. 

Column =
RANKX (
    CALCULATETABLE (
        Quotations,
        ALLEXCEPT ( Quotations, Quotations[LaneID], Quotations[Bracket] )
    ),
    Quotations[Rate],
    ,
    ASC,
    DENSE
)
  • onkelphill's avatar
    onkelphill
    Frequent Visitor
    8 years ago

    v-chuncz-msft 

     

    thank you very much.

     

    Actually, i found this example and it is exactly what i am looking for. 

     

    However, although i am following the instructions it does not work for me. This is the error message i am getting:

     

    "A table of multiple values was supplied where a single value was expected"

     

    Any ideas?

     

    Thank you very much!

     

    • bsas's avatar
      bsas
      Post Patron
      8 years ago

      onkelphill

       

      This message says that you're using calculated column but should use measure instead.

      • onkelphill's avatar
        onkelphill
        Frequent Visitor
        8 years ago

        bsas

         

        i know. Funny thing is, looking at the example i linked above it works.