Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
dd88
Post Patron
Post Patron

dax to obtain totals of inbound calls and outbound calls for a month and year

‎02-07-2025 07:01 PM

I would like a dax to get totals of inbound calls and outbound calls for a month and year.

 

For example

Total INBOUND
2024
March 1300
April 220
May 440

 

Total OUTBOUND
March 1200
April 300
May 220

 

These are the powerbi column/fields

Month. values
January
February
March  ..etc

 

Year. values
2022
2023
2024
2024

 

call-direction. values
INBOUND
OUTBOUND

 

call-direction - 01.png

 

any info on this?

 

TIA

Labels:
Message 1 of 3
120 Views
0
1 ACCEPTED SOLUTION
danextian
Super User
Super User

‎02-07-2025 08:18 PM

hI @dd88 

 

Try these measures

outbound calls =
CALCULATE ( [aggregation], 'table'[call-direction] = "OUTBOUND" )


inbound calls =
CALCULATE ( [aggregation], 'table'[call-direction] = "INBOUND" )

Add month and year to your visual to see the breakdown.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

Message 2 of 3
82 Views
0
2 REPLIES 2
danextian
Super User
Super User

‎02-07-2025 08:18 PM

hI @dd88 

 

Try these measures

outbound calls =
CALCULATE ( [aggregation], 'table'[call-direction] = "OUTBOUND" )


inbound calls =
CALCULATE ( [aggregation], 'table'[call-direction] = "INBOUND" )

Add month and year to your visual to see the breakdown.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Message 2 of 3
83 Views
0
dd88
Post Patron
Post Patron
In response to danextian

‎02-08-2025 02:13 AM

that worked. Many thanks @danextian nice work

Message 3 of 3
66 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

View All