Sort Sold and Not Sold

[zan0n]

Hello,

Im trying to sort what was sold by a salesperson and what was not. The intent is to motivate them to sell what they havent sold, so they see what they havent sold together with how much they couldve made.

Relationships as follow:
dSupervisores[cod_supervisor] -> dVendedores[cod_vendedor] -> fEmprestimos[cod_vendedor]
dEsmprestimos_tabelas_tipo[tabtipcodigo] -> dEmprestimos_tabelas[tabcodigo] -> fEmprestimos[tabcodigo]

So it would be what dEmprestimos_tabelas_tipos[convenio_pai] dSupervisores[Supervisor Agrupado] sold and what it didnt, acompanied with the values from fEmprestimos that i already have. 
Expected result is:
Sold

convenio_pai	Value
B	31
C	34
D	44

Not Sold

convenio_pai	Value
X	5
Y	32
Z	115

Please let me know if the info and question are confusing. 
Apreciate the help!

[amitchandak · Accepted solution]

@zan0n , I think you need a solution like this

Power BI Items/Categories not sold to the customers: https://youtu.be/AbuKvAnicwo

You need sum up not sold

[zan0n]

Thank you for sharing the video! Helped me to understand the problem better.
I am still having trouble, i feel like youve put the solution right in front of my eyes but i still cant figure it out.
I cannot add the values of the categories they didnt sell. I have a measure SUM(fEmprestimos[valor_liquido]) that i would like to have next to the categories they didnt sell, showing what he coulve sold.
Your reply mentions i need to sum up not sold, but i, lost on where to apply that. 

Im trying to figure it out. Apreciate your help so far, and whatever else you can help me with!

[zan0n]

Solved using Amit's video and using a measure CALCULATE(VALUES, REMOVEFILTER(dSupervisores), REMOVEFILTER(dVendedores)). Thank you Amit!