Create measure using another measure and column

[Milan6687]

Hi,

I have created one measure named Quantity. Now I need to create one more measure using Toatl= Quantity * Table[cost].

Table looks like:

id   Month  ResvervedQty    cost

1     Jan         5                      100

1     Jan          7                      200

1     jan          9                      300

Suppose I have my Quantity = 7 , I need to use that cost which have same value as Quantity. In this case  toatl= 7*200

Thanks in Advance

[Anonymous]

Hi @Milan6687 ,

How to get the formula for Measure? Please provide more details and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Milan6687 , You can not create a measure and column together in new column

Try a measure like 

sumx (Table,[ResvervedQty ]*[Cost] )

[Milan6687]

But I need to compare Measure and cloumn value(ReservedQty) and based on this I need to select cost which will be then multiplied to my Measure.