Total amount fully divested & partially sold

[TracyTran]

Hi friends, 

I have a "F_Balance" fact table that is updated weekly, displaying the daily balances of investors. The investors can sell all of their stocks or partially. 
I would like to ask for a help to find out the amount which that the investors have fully divested and the amount which the investors have partially sold.

@ThxAlothas already assisted me in calculating the number of investors who have fully divested and those who have partially sold their holdings. Sample data is here PowerBI

To further explore this analysis, I have the following questions:

• What is the total amount that the investors have fully divested?

• What is the total amount that the investors have partially sold?

• What is the total amount invested by new investors?

• Can we display the number of investors who have sold all their stocks when using the matrix table in PowerBi? Currently, it only shows the number of investors who have partially sold their stocks.

Thank you for your help.

[CoreyP]

I've seen this exact question multiple times recently. Is there a training or certification course happening? 

[TracyTran]

Just from business questions which I need to find the answer 😞