Calculate Distintcount before it Does a filter from the date slicer

[tomb0]

the issue im running into is that if i do this measure

amount of In Time =

CALCULATE(

    DISTINCTCOUNT('AMP'[Source Handling Unit]),

    'AMP'[delay/in time]="In time"

)

in a cluster column chart with a date slicer, it wil count the distinctcount per days so that means the same Value on monday and thueseday not what i want 

what im looking for is doing my measure before the Date slicer.

is this possible if so how.  
many thanks.

[Ashish_Mathur]

Hi,

Does this work?

amount of In Time =

CALCULATE(DISTINCTCOUNT('AMP'[Source Handling Unit]),'AMP'[delay/in time]="In time",all(Calendar[Date]))

[Greg_Deckler]

@tomb0 Try adding an ALLEXCEPT to your measure to remove the date filter.

[tomb0]

The thing i need.

Is this but then after the measure is done.

i want date filter to work again.
is this possible?

[v-yiruan-msft]

Hi @tomb0 ,

I'm not sure whether the following measure is what you want...

amount of In Time =
CALCULATE (
    DISTINCTCOUNT ( 'AMP'[Source Handling Unit] ),
    FILTER ( ALLSELECTED ( 'AMP' ), 'AMP'[delay/in time] = "In time" )
)

If the above one can't help you get your expected result, could you please share some sample data and your expected result with backend logic and specific examples in order to provide you a suitable solution? Thank you.

Best Regards