countrows for distinct ID for headcount measure

[Pbiuserr]

Hello
My measure is and I would like to count only unique ID within it. Where to put that argument?

 
Headcount = 
VAR MinDate = MIN(Calendar[Date])
VAR MaxDate = MAX(Calendar[Date])
VAR result = CALCULATE(
        COUNTROWS(
                FILTER(
                        MainTable,
                        (MainTable[Termination Date-Employment Details] > MinDate || ISBLANK(MainTable[Termination Date-Employment Details])) && MainTable[Hire Date-Employment Details] <= MaxDate
                )
        ),
        MainTable[Employee Status] = "A",
)
RETURN
    result

[SpartaBI · Accepted solution]

@Pbiuserr try:

Headcount = 
VAR MinDate = MIN(Calendar[Date])
VAR MaxDate = MAX(Calendar[Date])
VAR result = 
	CALCULATE(
		DISTINCTCOUNT(MainTable[ID]),
		KEEPFILTERS(
			FILTER(
				ALL(MainTable[Termination Date-Employment Details], MainTable[Hire Date-Employment Details] ),
	            (MainTable[Termination Date-Employment Details] > MinDate || ISBLANK(MainTable[Termination Date-Employment Details])) && MainTable[Hire Date-Employment Details] <= MaxDate
	        )
        ),
        MainTable[Employee Status] = "A",
	)
RETURN
    result

      

Showcase Report – Contoso By SpartaBI

[Pbiuserr]

Thank you. It works as I can tell! 

Perhaps could you help me to do that in this way

Average measure =

DIVIDE( SUM(Maintable[Measure]), [Headcount] )
I'd like to SUM measure for distinct ID instead of for all / headcount - (this one is fixed)