Calculating Averages with conditions

[puj831]

How can I take the average of Price with the condition that Volume > 0?

[Claster · Accepted solution]

Maby Its depends of your Culture, try to use [  ,  ] instead of  [  ;  ] and try to count your 

[popov]

Hello, @puj831

Try this
AveragePrice := AVERAGEX (FILTER(YourTableName; YourTableName[Volume] > 0); YourTableName[Price])

or this

 AveragePrice := CALCULATE ( AVERAGE (YourTableName[Price] ); YourTableName[Volume] > 0 )

[puj831]

This is error I keep getting back. Any solutions? Thank you so much!

[Claster · Accepted solution]

Maby Its depends of your Culture, try to use [  ,  ] instead of  [  ;  ] and try to count your 

[popov · Accepted solution]

Try this
AveragePrice := AVERAGEX (FILTER(YourTableName, YourTableName[Volume] > 0), YourTableName[Price])

or this

 AveragePrice := CALCULATE ( AVERAGE (YourTableName[Price] ), YourTableName[Volume] > 0 )

[puj831]

Yes, that works. Thank you so much!