topic Re: Count Calls (Inbound and Outbound) Yesterday in DAX Commands and Tips

Count Calls (Inbound and Outbound) Yesterday

Aimeeclaird — Thu, 12 Mar 2020 13:08:40 GMT

Hi, hopefully someone can help!

I want to include a visual in my report that shows the percetage of inbound vs outbound calls yesterday (thinking a pie or doughnut chart?)

I am struggling however to count and filter the data. The formula I am trying to use is:

Inbound Calls Yday = calculate(

countax(Inbound_Calls[StartDate]),

filter(Inbound_Calls, Inbound_Calls[StartDate] = [Yesterday]))

** Note, I have a measure in my date table [Yesterday] which is basically just Today()-1

The formula above returns 'Blank'

Please can someone tell me how I can count the calls yesterday?

Re: Count Calls (Inbound and Outbound) Yesterday

az38 — Thu, 12 Mar 2020 13:25:49 GMT

Hi Aimeeclaird

try more easy

Inbound Calls Yday = calculate( counta(Inbound_Calls[StartDate]), Inbound_Calls[StartDate] = (TODAY()-1) )

Inbound Calls Yday = calculate( counta(Inbound_Calls[StartDate]), Inbound_Calls[StartDate].[Date] = (TODAY()-1) )

Re: Count Calls (Inbound and Outbound) Yesterday

Aimeeclaird — Thu, 12 Mar 2020 13:29:16 GMT

Thanks for your help - appreciate you taking the time. Can I ask where I was going wrong please?

Re: Count Calls (Inbound and Outbound) Yesterday

az38 — Thu, 12 Mar 2020 13:33:22 GMT

Aimeeclaird

first, countaX() has another syntax - COUNTAX(<table>,<expression>) https://docs.microsoft.com/en-us/dax/countax-function-dax

second, FILTER in measure uses row context, so you need use FILTER(ALL(Table),..)

third, as you have the only simple expression over all amount of data it is not mandatory to use filter, you could filter out useful falues just by CALCULATE(<expression>,<filter1>,<filter2>…)