Table visualization overloaded (max entries reached)

Hi all! 

Hope you can help me with this, I'm having a hard time trying to get this into a funtional visual. I'm doing an analysis on retail sales opportunities based on Sales and Distribution, therefore I have identified 3 kinds of opportunities:

1. No distribution - stores/skus where Inventory=0 and L4Wk Sales=0

2. Out of Stock - stores/skus where Inventory=0 and L4Wk Sales>0

3. Phantom Stock - stores/skus where Inventoru>0 and LWk Sales=0

I have managed to create the measures to have the "count" of store/sku combinations for each of the opportunities, however when trying to show the detail on a table or matrix visual it crashes due to the amount of rows it's trying to show, I've tried reducing the rows by showing a higher level of aggrupation (instead of SKU showing category) but then the total shown in the table does not show properly. I believe there should be a way to maybe create a new summarized table for each kind of opportunity or maybe counting the rows in a different way so that when showing in a "grouped" visual the total shown is correct, but as of now I have not been able to do it in a way that works properly.

Below is a link to my PBIX, tables are now working because there are slicers on Category and Customer but when removing this tables crash, I'd appreciate any help on how to have a solution for this!

https://pbixfiles

Thanks in advance!!!

Ale