Table visualization overloaded (max entries reached)

[aavilap]

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

[TomMartens]

Hey,

I'm wondering how many GB of RAM you have available.

With 16GB of RAM it is possible to remove the filter from the slicers: category and customer.

Besides that, I removed the option "Show items with no data" from the customer field.

Actually, I'm wondering why there is a table visual that maybe shows 130M rows, I would try to avoid this possible outcome and start to redesign the report page - if possible.

No sure, but maybe this gives you an idea.

Regards

Tom

[aavilap]

Thanks @TomMartens I’m running on an 8GB RAM PC, the reason so many rows show is I have ~35,000 SKUs and 5,000 stores which gives me a lot of possible combinations. Since most of my final users might not be running on a 16GB RAM I need to figure out a different way to show this, do you have any suggestion on how I could achieve this? Thanks in advance!!!!

[aavilap]

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