How to not have duplicate values counted in pie chart?

[Anonymous]

I am new to Power BI and I am trying to make a pie chart from two tables. 

My first table is a list of all the vehicles we sold in 2022 and my second table is a list of all the vehicles that were sold in 2022 but repossessed in the same year.

The total in my first table is 507 and the total in my second table is 73. I need the 73 to show up as a portion of the 507, but rather it's showing up seperate.

I've already created a one-to-one relationship between the two tables linking the account numbers. 

I hope this makes sense. It should be 507 total with 73 as a portion of the 507, making the percentage 14.40%

Can someone let me know if there is a way to only count the same contracts once?

Or, should I go back and change my data with one table containing only accounts that are still active from last year and one table containing the sold & repossessed accounts from last year?

[Ashish_Mathur]

Hi,

Here's a general idea.  Create a calculated column formula in Table 1 to bring over the Date of repossession from Table2.  Write another calculated column formula in Table1 to show the status (Repossessed and Active) based on whether the new new column that you created has a date or not.  Now write your measures.

[amitchandak]

@Anonymous , Check if custom labels can help

Custom label
https://www.youtube.com/watch?v=IH4bcHhxunw
Dynamic Label
https://www.esbrina-ba.com/time-intelligence-dynamic-legend-in-line-charts/