The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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' ) )
)
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' ) )
)
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
10 | |
8 |