Calculate average of a column using the number of months from the filter

[USur]

I have a table containing counts of tickets created and resolved by client name and the table can be filtered using the date range/relative date. I would like to create another column that would calculate the average of tickets created and resolved based on the count of months filtered. 

How do I develop the DAX formula to get this result? Any suggestions?

[USur]

Hi,

Customer	10%	20%	30%	40%	50%	60%	70%	80%	90%	100%	Total Tkts Created	Total Tkts Resolved
A	0	0	0	0	1	2	3	8	15	55	559	492
B	0	0	0	0	0	1	2	4	9	64	320	335
C	0	0	0	1	1	2	4	5	13	55	276	266
D	0	0	0	1	2	5	10	16	34	77	242	243
E	0	0	0	0	1	1	2	4	8	30	208	210
F	0	0	0	1	2	2	4	6	11	63	137	110
G	0	0	0	1	1	2	4	6	10	46	124	103
H	0	0	0	1	1	2	5	7	12	18	83	70
I	0	0	1	2	3	4	7	9	21	51	79	71

This is the data and I would like to calculate the average of tickets created based on the number of months selected from the filter that shows relative date in months.

Regards,

Uditi

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523