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.
Hi,
We have a measure and had thought average exzcluded blanks by default - have lots of rows some with values some with blanks
We set the measure to blank if value is 0 and then do average on measure but looks to ber still dividng by number of rows as opposed to number of non-blank rows.
Can ensure set on database to null and the average works but wondered
How can we best acieve an average ignoring values with blank and 0's in power bi?
Thanks
Solved! Go to Solution.
@po,
You can create a measure using DAX like pattern below:
Result = AVERAGEX ( FILTER ( Table, Table[Value] <> BLANK () ), Table[Value] )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@po,
You can create a measure using DAX like pattern below:
Result = AVERAGEX ( FILTER ( Table, Table[Value] <> BLANK () ), Table[Value] )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That worked for me too. But I need to apply this logic to a daily average.
So it would be the mix of the 2 below. Any idea how to do it?
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |