Different data when filter is on

[Anonymous]

Hi,

Currently using this expression to count answered calls less than 30 sec per ID conversation and it's working nicely.

Count( Distinct {<[Aggr tAnswered] ={"=sum([Aggr tAnswered])/1000<=30"},[Aggr nAnswered] ={1}>} [ID: Conversation])

However, when I filter it by date, the numbers reflected on the totals is incorrect.

e.g. BEFORE FILTER: Oct 19 calls = 8 below 30 sec, 2 above threshold

AFTER FILTER: showing just Oct 19 data, calls = 10 below 30 sec.

Would appreciate your insights to this. Thanks!

[agigliotti]

what's your expected result after date selection ?

[sunny_talwar]

May be try this

Count(DISTINCT {<[Aggr tAnswered] = {"=Sum({<Date>}[Aggr tAnswered])/1000<=30"},[Aggr nAnswered] ={1}>} [ID: Conversation])