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 Team ,
I would like to ask for you help, Basically I have a table for IT Insidents , and Table for IT Requests ..
in Each table there is a Column where all ticket numbers are listed, so I use count to know how many Riquests , and how many incidents ,
However i want to SUM both , how can i do that, i'm working on a dashboard where i'll show ticket per region , and total tickets handeled by teams etc .. so i need to combine both Requests & Insidents .
Note : the two tables are related to each other by Region Column,.
Thanks
Solved! Go to Solution.
@hadoka it should be straight forward:
Total Tickets = COUNTROWS( Table_Incident ) + COUNTROWS( Table_Tickets )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thank you Team .. the first solution worked for me 🙂 .. all the best..
Hi @hadoka,
Please share some sample data to help us clarify your scenario.
In my opinion, I'd like to suggest you use current region value to find out correspond ticket id list, then you can simply get he count of related id request.
Ticket Count = CALCULATE ( COUNTROWS ( VALUES ( 'IT Insidents'[TicketID] ) ), VALUES ( 'IT Insidents'[Region] ) ) Request Count = VAR ticketList = CALCULATETABLE ( VALUES ( 'IT Insidents'[TicketID] ), VALUES ( 'IT Insidents'[Region] ) ) RETURN CALCULATE ( COUNTROWS ( 'IT Requests' ), FILTER ( ALLSELECTED ( 'IT Requests' ), 'IT Requests'[TicketID] IN ticketList ) )
Regards,
Xiaoxin Sheng
@hadoka it should be straight forward:
Total Tickets = COUNTROWS( Table_Incident ) + COUNTROWS( Table_Tickets )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |