Forum Discussion
Solved
Calculating Averages with conditions
How can I take the average of Price with the condition that Volume > 0?
Maby Its depends of your Culture, try to use [ , ] instead of [ ; ] and try to count your
Try this
AveragePrice := AVERAGEX (FILTER(YourTableName, YourTableName[Volume] > 0), YourTableName[Price])
or thisAveragePrice := CALCULATE ( AVERAGE (YourTableName[Price] ), YourTableName[Volume] > 0 )
This is error I keep getting back. Any solutions? Thank you so much!
Maby Its depends of your Culture, try to use [ , ] instead of [ ; ] and try to count your