Average per Program

[inglexjc]

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 data will have blanks.  Is there a way to exclude the blanks in the average calculation?  I would like to show the end results in a bar graph.

Program	Complaint Received Date	Case Closed Date	Days to closure
SNAP	6/17/2025
AF	5/27/2025	7/23/2025	68
MA	7/01/2025	7/24/2025	23
MA	7/02/2025	7/24/2025	22
SNAP	6/04/2025	7/23/2025	49

[Ashish_Mathur · Accepted solution]

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.

[inglexjc]

@Ashish_Mathur Is there a way to get the average based on the program?  It looks like it has the same average for each program.

[Ashish_Mathur]

Hi,

Looks like there is some problem with the relationship.  Share the download link of the PBI file and show the problem there very clearly.

[inglexjc]

I was able to fix the relationship.  

Thank you again.

[ExcelMonke]

Hello,
You can consider the following DAX

CALCULATE(
AVERAGE(Table[Days to Closure]),
Table[Days to Closure] <>"")