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
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
Icon for Post Patron rankPost 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.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi onkelphill,

       

      Have you resolved this problem?  If not, share the link from where i can download you file and also show your expected result there.