Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Hi All,
I want to multiple selling price by QTY. the Selling price is in a different row to QTY. where selling price is being mentioned the QTY is zero and where the QTY has been mentioned the selling price is zero.
I have added the screen shot of my data.
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Expected invoice value: =
SUMX (
ADDCOLUMNS (
SUMMARIZE ( Data, 'Item'[Item] ),
"@qty", CALCULATE ( SUM ( Data[Qty] ) ),
"@unitprice", CALCULATE ( MAX ( Data[Unit Price] ) )
),
[@qty] * [@unitprice]
)
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.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Expected invoice value: =
SUMX (
ADDCOLUMNS (
SUMMARIZE ( Data, 'Item'[Item] ),
"@qty", CALCULATE ( SUM ( Data[Qty] ) ),
"@unitprice", CALCULATE ( MAX ( Data[Unit Price] ) )
),
[@qty] * [@unitprice]
)
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.
User | Count |
---|---|
21 | |
19 | |
12 | |
10 | |
9 |
User | Count |
---|---|
30 | |
25 | |
15 | |
13 | |
10 |