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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
luisecp
Frequent Visitor

Get Total Sales with Sales history and Price List

I have two tables

 

Sales history

 

Product NoOperation

Apple       1

Orange     2

Apple        3

Banana       4

Banana       5

Banana       6

 

Table Prices

 

Product  Price

Banana    10

Apple      20

Orange     30

 

I want GET in PB

 

Table of Total Sales:

 

Product  Price  Total Sell

Banana    10        30                                    10*3   (I sold 3 bananas)

Apple      20        40                                     20*2  (I sold 2 apple)

Orange     30       30                                    30*1 (I sold 1 Orange)

 

Regards

 

Luis

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

It is for creating a measure.

 

Untitled.png

 

Total sell measure: = 
SUMX (
    'Price',
    'Price'[Price] * COUNTROWS ( RELATEDTABLE ( 'Sales history' ) )
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

It is for creating a measure.

 

Untitled.png

 

Total sell measure: = 
SUMX (
    'Price',
    'Price'[Price] * COUNTROWS ( RELATEDTABLE ( 'Sales history' ) )
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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