Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Write a Measure with Relation

Hello,   I was looking in the Forum and I searched a lot in the internet.  I am looking for a Measure, where I can tell a Relation.   For example: I earn a sum X for an order. I pay X€ for the d...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hello amitchandak,

     

    thanks, I try to define it a little more 🙂 

     

    Values & Measures for order values:

    RG DB Real ohne GS S. = SUM(Prdo5_Sales[RG DB Real ohne GS]) 

     

    Values & Measures for delivery costs:

    UPS Fracht_Netto = sum('UPS Invoice'[FRT Net charge])

     

    I don't understand what you mean with Order ID. Do you mean something like an invoice number or is this a expression I don't know yet?

     

    I tried your formular as followed: 

    DB€ auf 1€ Fracht = SUMX(VALUES('UPS Invoice'[FRT Net charge], 'UPS Invoice'[UPS Nettobetrag], [UPS Fracht_Netto] - [RG DB Real ohne GS S.]))

    I get the following error:

    Too many arguments were passed to the Values function. A maximum of 1 argument is allowed for the function.

     

    Thanks again in Advance 🙂

  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , values parenthesis ")" is not closing before comma

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , There is something known as related that can help copy data from 1side to many side table.

 

Else you need a common, order table measure like order value and delivery value .

 

Final measure =

sumx(values(OrderIS[Order ID]), [Order value]- [Delivery Value]) )

 

both order and delivery are joined to a common orderid table

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello amitchandak,

     

    thanks, I try to define it a little more 🙂 

     

    Values & Measures for order values:

    RG DB Real ohne GS S. = SUM(Prdo5_Sales[RG DB Real ohne GS]) 

     

    Values & Measures for delivery costs:

    UPS Fracht_Netto = sum('UPS Invoice'[FRT Net charge])

     

    I don't understand what you mean with Order ID. Do you mean something like an invoice number or is this a expression I don't know yet?

     

    I tried your formular as followed: 

    DB€ auf 1€ Fracht = SUMX(VALUES('UPS Invoice'[FRT Net charge], 'UPS Invoice'[UPS Nettobetrag], [UPS Fracht_Netto] - [RG DB Real ohne GS S.]))

    I get the following error:

    Too many arguments were passed to the Values function. A maximum of 1 argument is allowed for the function.

     

    Thanks again in Advance 🙂

    • amitchandak's avatar
      amitchandak
      Super User
      3 years ago

      Anonymous , values parenthesis ")" is not closing before comma