Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Thanks in advance!!!
Ale
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
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!
Thanks in advance!!!
Ale