Showing values in one dataset missing from another dataset on pie chart

[techtina]

I have 3 datasets.

• Dataset A --> this is the “master” excel file with SenderName, SenderID, ShipmentNo. This represents total shipments.
• Dataset B --> this is a sql server query which I merged with Dataset A to pull ShipmentNo’s in the database included in Dataset A. Not all shipments in Dataset A are included in Dataset B.
• Organization table --> this is a database table which is connected to the SenderId in Dataset A and SenderOrganizationID in Dataset B

The purpose of this pie chart is to show the proportion of distinct ShipmentNo’s in Dataset A that is not included in Dataset B. In the pie chart below, there are 40 total shipments under that specific organization, and 39 of those shipments are missing, meaning not included in Dataset B. Therefore, the red part should cover most of the pie chart, not split in half like below.

The values in the pie chart at the moment are a result of measures I had initially created:

Total Shipments  = DISTINCTCOUNT('Dataset A'[ShipmentNo])

Shipmentcount = DISTINCTCOUNT(Milestones[ShipmentNo])

Missing Shipments = [Total Shipments] - [Shipmentcount]

 

I realized that merely finding the difference in the distinct count between both datasets will not solve my problem. However, I am stuck because I’m also unable to create a direct relationship between Dataset A & B. If anyone can help me find a workaround, it would be greatly appreciated!

[v-ljerr-msft]

Hi @techtina,

Could you share a dummy pbix file which can reproduce the issue, so that we can better assist on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[techtina]

Hi @v-ljerr-msft, 

I greatly appreciate your help since I am still stuck on this. To simplify it, I am basically trying to show the measure "CountFalse" as a proportion of the "Total Shipments" measure in the pie chart. In the pbix file, I'm trying to get the pie chart to read: "39 out of the 40 distinct shipments are false under organization TOL." Therefore, the red portion should cover 97.5% of the pie when sliced by TOL. 

Here is the link to the file on one drive: https://1drv.ms/u/s!Ao2_nHZB2FWRbxLiiIbwp0iax9w

[Vvelarde]

@techtina

Hi

Put in Legend Your Matched Column

And In Values Total Shipment

Regards

Victor

[techtina]

Hi @Vvelarde,

That won't work in my case because I need the whole pie to represent the total, and "false" to show the portion of the total it makes up. The total is a distinct count, and so is the the matched column. 

[Vvelarde]

@techtina

Hi, Do you want to see like this?

[techtina]

@Vvelarde, @v-ljerr-msft

Nope. That pie chart reads out "out of 40 total distinct shipments for TOL, 39 are false and 1 is true." 

I want the pie chart to disregard "true." It should read "Out of 40 total distinct shipments for TOL, 39 of them are false." So 39 should be the majority of the pie. 

Thanks for your help!