Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Laura0403
Frequent Visitor

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 delievery. How much income do I have per 1 € delievery costs?

I try to make a report, where I need to use a lot of such measures. The absolut numbers are not that meaningful. The important things are the relation numbers. 

Unfortunatly, everytime I google "Power Bi" and "Relation" I always get infos about the Relations in the Model (which makes sense, but is not what I need :D) 

 

Thanks in advance. 🙂

2 ACCEPTED SOLUTIONS

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]) 

Laura0403_2-1663577551381.png

 

Values & Measures for delivery costs:

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

Laura0403_1-1663577524527.png

 

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.]))

Laura0403_0-1663577450353.png

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 🙂

View solution in original post

@Laura0403 , values parenthesis ")" is not closing before comma

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Laura0403 , 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.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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]) 

Laura0403_2-1663577551381.png

 

Values & Measures for delivery costs:

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

Laura0403_1-1663577524527.png

 

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.]))

Laura0403_0-1663577450353.png

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 🙂

@Laura0403 , values parenthesis ")" is not closing before comma

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.