Forum Discussion
Need help with measure
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
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
Anonymous
Try a measure like
SUMX(table,table[order_amount] * table[price])
4 Replies
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
Anonymous
Try a measure like
SUMX(table,table[order_amount] * table[price])