Calculate the Benchmark for the no of files and persons associated

[dshah12]

I want to calculate the benchmark for total count of files / Owner

I tried Count,DistinctCount,Distinctcountnoblank etc but none of them works perfectly.

Also tried 

Benchmark = AVERAGEX(

    KEEPFILTERS(VALUES(Owner)),

    CALCULATE(COUNT(File nos))

)

I get infinity certain. Help appreciated 

File nos	Owner
CRM1232	ABC
CRM1232	ABC
CRM145	XYZ

[amitchandak]

@dshah12 , Try like

a measure

M1 = 

AVERAGEX(
VALUES(Owner),
CALCULATE(COUNT(File nos), allexcept(Table[Owner]) )
)

or

M1 = AVERAGEX(
VALUES(Owner),
CALCULATE(COUNT(File nos), allselected() )
)

[dshah12]

No that doesn't work Thank you for answering