Forum Discussion
Solved
Average per Program
I'm trying to show average days it took for a complaint to be received till the case was closed by program. I'm unable to upload PBIX data. Here is an example of what it looks like. Some of the d...
Hi,
Blanks are by default excluded in an average calcualtion. If Days to Close is already a column in your table, then write this measure
Avg = average(Data[Days to close])
Hope this helps.
Hello,
You can consider the following DAX
CALCULATE(
AVERAGE(Table[Days to Closure]),
Table[Days to Closure] <>"")