topic DAX expression for counting a column that is grouped with another column in DAX Commands and Tips

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

micheledubose — Tue, 12 Jan 2021 20:46:44 GMT

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.

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

AlB — Tue, 12 Jan 2021 21:17:58 GMT

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

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

micheledubose — Wed, 13 Jan 2021 01:00:50 GMT

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?