Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 this
AveragePrice := CALCULATE ( AVERAGE (YourTableName[Price] ), YourTableName[Volume] > 0 )
Hello, @puj831
Try this
AveragePrice := AVERAGEX (FILTER(YourTableName; YourTableName[Volume] > 0); YourTableName[Price])
or this
AveragePrice := 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
Try this
AveragePrice := AVERAGEX (FILTER(YourTableName, YourTableName[Volume] > 0), YourTableName[Price])
or this
AveragePrice := CALCULATE ( AVERAGE (YourTableName[Price] ), YourTableName[Volume] > 0 )
Yes, that works. Thank you so much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |