Forum Discussion

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
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
3 years ago
Anonymous , values parenthesis ")" is not closing before comma