DAX expression for counting a column that is grouped with another column

[micheledubose]

Hello,

I am new to DAX expressions.  I have a SSRS project that is pulling data from a SQL Server Analysis Services database. The SSAS project is in DirectQuery mode. Below is what I'm attempting to accomplish.

Month        Day             Incoming Calls  Outgoing Calls  Total Calls     

12/2020     12/1/2020   4                        3                       7

                  12/2/2020   1                        2                       3

Total Incoming Calls   Total Outgoing Calls   Total Monthly Calls

5                                  5                                  10

What I have currently is a table like this:

Date              Incoming Calls (extention phone number)   Outgoing Calls

12/1/2020      1234                                                             5555

12/1/2020      4321                                                             1111

12/1/2020      6268                                                             2222

12/1/2020      6322

12/2/2020      6657                                                             3333

Using DAX, how can I aggreate the values for Date, Incoming and Outgoing Calls?  Basically, for Date, I don't want it to be listed but grouped.  For Incoming and Outgoing Calls, I need the count of calls per date.  For the total calls, I need the sum of all incoming calls, outgoing calls, and total calls for the month.

[AlB]

Hi @micheledubose 

1. Place Date ina  table visual

2. Place these measures in the visual:

 Inc calls = COUNT(Table1[Incoming Calls (extention phone number)])

 Out calls = COUNT(Table1[Outgoing Calls])

Total calls = [Inc calls] + [Out calls]

It would be better to use a date table

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[micheledubose]

Hi @AlB,

Just to make sure my explanation was clear, my report is created as a Reporting Services project in Visual Studio.  When you say, "place data in a table visual", is this possible in a Report Services project?