How to measure two other measure in one column?

[selected_]

Ok so I have two mesaure like this 

Avg ProductID+OrderID = AVERAGEX(VALUES(Products[ProductID]), CALCULATE(AVERAGE('Order Details'[OrderID])))

Selling Price = AVERAGE('Products'[UnitPrice]) * (1-[Total Discount])

I tried with this but getting wrong number in return.

Average Selling Price = [Avg ProductID+OrderID]/[Selling Price]

My goal is to get all these three measure below into one column 

avg([ProductID], avg([OrderID],[Selling Price]))

and to get an Average Selling Price in return.

Anyone can help?

[amitchandak]

@selected_ ,

Selling price need to like

Selling Price = divide( sumx('Products','Products'[UnitPrice] * (1-[Total Discount])) ,Sum('Products'[UnitPrice]))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Greg_Deckler]

@selected_ - Can you show a screen shot or something of where you are getting a wrong value? You generally do not want to use measures in calculated columns if that is what you are trying to do.

[selected_]

I'm getting correct result number on each measure below 

Avg ProductID+OrderID = AVERAGEX(VALUES(Products[ProductID]), CALCULATE(AVERAGE('Order Details'[OrderID])))

Selling Price = AVERAGE('Products'[UnitPrice]) * (1-[Total Discount])

But the final step to get the Average Selling Price is I think I have to somehow calculate the Selling Price column and filter by the other column Avg ProductID+OrderID.

Is that possible way to do it?

[v-xuding-msft]

Hi @selected_ ,

For your requirement, I'm not clear. What do you mean that Average Selling Price is filtered by the other column Avg ProductID+OrderID? 

Can you please share some screenshot, sample data and your expected results? Then we will understand clearly and solve it quickly.