Forum Discussion
Dynamic segmentation over two dimensions
Anonymous - Just FYI I downloaded the file and am taking a look. Just so that I can understand in words what you are trying to do... OK, I have no idea, can you explain in words what you are trying to do? I see there are price buckets. I see that there is a volume difference. There are 2 products, do they both fall into the same price buckets or different price buckets. Are you trying to show that product 1 falls into price bucket A and has this much volume versus product 2 falls into price bucket B and has this other volume?
Sorry, I'm not clear on this at all. Please @ me in any reply. Thanks.
Hey Greg_Deckler
Thank you for replying. Here's what I am trying to do. We're a FMCG distribution company; we distribute products, but we also manufacture and distribute our own branded products. The aim of the model is to bucket theprice difference between the market related product and our own brand product, so that we can compare the volume difference within each bucket.
If you look at the 2 calculated tables, Summarize1 act as the harvesting table, where Summarize2 is where I bucket price difference to compare the volume difference. But, ideally this can all be done inside a measure so that can be fully dynamic.
Hope this makes sense 🙂
Hi Anonymous
You might consider providing your dummy pbix that would be helpful for us to investigate it further.
You can upload it to the onedrive for business and share the link here.
Hello v-diye-msft ,
A model and downlink was provided in the original post, however, happy to provide it again here:
https://1drv.ms/u/s!AiMOn9aJXFVYiEuADxfKXTgHdi_7?e=fa71cJ
Please let me know if you can download the Power BI report.
Thank you,
Deston
