Get Total Sales with Sales history and Price List

[luisecp]

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

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a measure.

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