All / slicer issue, discards data

MrNoob thanks for providing the data.  I am with v-juanli-msft above although I have no issue with realistic data (actually I think this is better).  What you have provided is not a good approach, especially in this case.  This is a non-trivial problem to be solved.  There is not 1 easy magic formula that you are overlooking - it is a complex problem that will require good table design as well as (likely) some tricky DAX.  To solve the issue, you will need to set up tables like specified by v-juanli-msft above.  You will also need to set up a matrix showing what your formula does now, and what numbers you expect to see.  It is often useful to show a working example in Excel to clearly desccribe the problem.  You know what you want but we don't, so you need to help us help you.