Need help with measure

[jwi1]

Good day,

I have a very simple question, but so far I did not succeed to solve it 😁

Below is a simple table.

I added a column with a calculation:

total_listprice = SUM(table[order_amount] * price

But what if I want to make this calculation with a measure, how should this measure look like?

How should I cope with the 'price', as this is a only a value.

order_amount	partnumber_sup	price	description	total listprice
10	045002700	785	BEARING, SHAFT END	7850
10	045002701	653	BEARING	6530
20	045002701	653	BEARING	13060
1	070023800	2553	WRENCH, REFRIGERATION	2553
1	070023801	2478	WRENCH, OFFSET REFRIGERATION	2478
				32471

Thanks!

John

[VijayP · Accepted solution]

The Measure would be 

SUMX([Name of the Table],Order_qty*Price), this will help you without creating a column to get the visual. 

with above measure you need not have another column which you have created with SUM function.

You can understand this in my Video Example , you can look at 2:30 of Video and you will find how to use this formula

You can watch many videos at my youtube channle (ref above link)

If you find this as solution please mention this as solution and Share your Kudoes

Regards

Vijay Perepa

[amitchandak · Accepted solution]

@jwi1 

Try a measure like

SUMX(table,table[order_amount] * table[price])

[jwi1]

Problem solved, thanks!

[VijayP · Accepted solution]

The Measure would be 

SUMX([Name of the Table],Order_qty*Price), this will help you without creating a column to get the visual. 

with above measure you need not have another column which you have created with SUM function.

You can understand this in my Video Example , you can look at 2:30 of Video and you will find how to use this formula

You can watch many videos at my youtube channle (ref above link)

If you find this as solution please mention this as solution and Share your Kudoes

Regards

Vijay Perepa

[jwi1]

problem solved, thanks!