Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic segmentation over two dimensions

Hello community   Hoping someone can assist.    I've a unique scenario where I am attempting to dynamically segment the price difference between two products. My model has 2 product dimensions, a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 🙂 

v-diye-msft's avatar
v-diye-msft
Community Support
5 years ago

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.