Handled % overall

[unnijoy]

I have a table with Ticket number,Country, Month & HC. I have to calulate the handled % 

Formula = total ticket/ Avg( HC).

I am getting issue when i need to find the overall for a collection of month. Their the formula shoule be 

Overall= Avg ( Monthly handled %).

As per below table for india Hadled % will be For July =5/626=0.8% | Aug = 7/592 = 1.2% | Sep = 7/657 =1.1%

As per the required formula its should be:
Overall Handle % = Avg(0.8 %,1.2%,1.1%) = 1.0%

Contacts	Country	Month	HC
TIC-5214	INDIA	July, 2019	626
TIC-5672	INDIA	July, 2019	626
TIC-5653	INDIA	July, 2019	626
TIC-5652	INDIA	July, 2019	626
TIC-5647	INDIA	July, 2019	626
TIC-6068	INDIA	August, 2019	592
TIC-6338	INDIA	August, 2019	592
TIC-6330	INDIA	August, 2019	592
TIC-6297	INDIA	August, 2019	592
TIC-6289	INDIA	August, 2019	592
TIC-5920	INDIA	August, 2019	592
TIC-5861	INDIA	August, 2019	592
TIC-7248	INDIA	September, 2019	657
TIC-7226	INDIA	September, 2019	657
TIC-6891	INDIA	September, 2019	657
TIC-7272	INDIA	September, 2019	657
TIC-7195	INDIA	September, 2019	657
TIC-7178	INDIA	September, 2019	657
TIC-7148	INDIA	September, 2019	657

[mahoneypat]

Please try this expression, replacing Table with your actual table name

Avg Monthly Handled =
VAR __summary =
    ADDCOLUMNS (
        SUMMARIZE ( Table, Table[Country], Table[Month] ),
        "@count", CALCULATE ( COUNTROWS ( Table ) )
    )
RETURN
    AVERAGEX ( __summary, [@count] )

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[unnijoy]

@mahoneypat 

in the measure that you gave i am not able to understand wer we are calculation the total Ticket count and Avg of HC. Bec when i use the formula it is not giving me corect valuse, Can you please check and confirm.

[mahoneypat · Accepted solution]

My bad.  I must have got distracted and didn't finish the measure.  Only got the numerators.  Please try this updated expression.

Avg Monthly Handled =
VAR __summary =
    ADDCOLUMNS (
        SUMMARIZE ( Table, Table[Country], Table[Month] ),
        "@count", CALCULATE ( COUNTROWS ( Table ) ),
        "@avg", CALCULATE ( AVERAGE ( Table[HC] ) )
    )
RETURN
    AVERAGEX ( __summary, DIVIDE ( [@count], [@avg] ) )

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat