Forum Discussion

Aimeeclaird's avatar
Aimeeclaird
Helper IV
6 years ago
Solved

Count Calls (Inbound and Outbound) Yesterday

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 how...
  • az38's avatar
    az38
    6 years ago

    Hi Aimeeclaird 

    try more easy

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

    or

    Inbound Calls Yday = calculate(
counta(Inbound_Calls[StartDate]),
Inbound_Calls[StartDate].[Date] = (TODAY()-1)
)
Aimeeclaird's avatar
Aimeeclaird
Helper IV
6 years ago

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

az38's avatar
az38
Community Champion
6 years ago

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>…)