Sum of filtered distinctcounts

[BileMG]

Hi,

I want to sum the working days of an selected time period. 
I have a Table that constists of the Ticket ID, the date of the Ticket and the ID of the Agents.

When I select one Agent my measure already works , because I Distincrcount the number of the Dates and as an result the number of working days in the selected period.

But when I selcect a team, that consists of many Agents it won't work for sure. So I am looking for a DAX that sums the Number of Working Days for every Agent within the selected Team.

Has anybody a Idea how should I do this ?

[MFelix · Accepted solution]

Hi @BileMG,

You should use an aggregator measure something like:

SumOfMeasure =
IF (
    HASONEVALUE ( Table[Techniker] );
    [Anzahl von ERL(IF6) Date];
    SUMX ( ALL ( Techniker ); [Anzahl von ERL(IF6) Date] )
)

Regards,

MFelix