Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am having 2 tables case-data and Incident. The relationship between these two table is one to many i.e 1 service request can be associated with multiple problems hence multiple support tickets.
Case-data table has primary key as ServiceRequestNo
Incident Table has Foreign key as Support ID No
The problem is initially I see all the possible Service Requests but as soon as I add Support Ticket ID field to my report values it shows me only those service requests which have a support ticket.
In technical terms, this is more like an inner join whereas I want left join because incident table has team name and I want to filter by how many total cases came to a particular team.
Can someone help me how can I fix this?
Solved! Go to Solution.
can you show how you related these two tables on the relationship view? that is probably where your issue lies.
Luis.
Please see below the relationship between the tables.
You probably need
https://docs.microsoft.com/en-us/power-bi/desktop-show-items-no-data
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |