Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX: Exclude where Measure = 0 in certain Row context, within another Measure (.PBIX Included)

Hi guys,   I try to calculate an average price for material stocks. I simply base this on the total value of the stock divided by the total volume of the stock.   Value per TON = 'Fact Invento...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

Try the following code:

 

Value per TON = 
DIVIDE([Closing Stock Value], CALCULATE([Closing Stock], FILTER(ALLSELECTED('Fact Inventory'),[Closing Stock Value] <> 0))