Forum Discussion
Help - with Visual/Dax
Hi all, I really don't know how to put this in the subject heading so thanks for reading.
I have been struggling with this problem for a while, hoping someone can help.
I have 3 columns, name, department, callid. There are many rows per callid, and the same callid refers to the same call.
My data looks like the below, I want to show in a visual table, the department the calls originated, and sum of them transferred to only the parts department.
I want to create a visual that shows the below
1 Reply
- VahidDMSuper User
Hi Anon29
Can you post more sample data as text and expected output?
please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables
Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/