Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |