Profit prediction - Discounting Scenarios

Power BI Data Model
1

Hi all,

I’ve been studying the aforementioned webinar and I was wondering how the model should be changed in order to accomodate a higher Product level (subcategory).

Assuming that there is a one-to-many relationship between Products table and Subcategory table, it would be great to run these scenarios based on subcategories.

BR / Efthimios

2

Hello @Thimios,

Thank You for posting your query onto the Forum.

Well rather than maintaining two tables one for “Product Category” and other one for “Product Sub-Category”. You can merge/subsume these two tables and have one combined table for these which will be easier than to have the analysis.

Hoping you find this useful. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

3

Thank you @Harsh,

  1. Model-wise, is it better to have a merged table rather separate tables for Master Category / Category / Subcategory?

  2. Even in this case, when selecting a subcategory, the Products table in Sam’s model get filtered leading to wrong calculation of the Non Selected Items. Is it feasible when selecting a Subcategory to check only the relative products?

BR / Efthimios

4

Hello @Thimios,

For Point No. 1 - Yes, model wise it’s better to keep them intact into the one table.

For example, when we’ve a locations table, in that we’ve fields for Address, Town, City, Territoty and Country so now in this case we don’t start creating different master tables for each of the fields/category. So yes, definitely you can combine them into the one table rather than maintaining multiple tables which share the same attributes.

For Point No. 2 - I’m not sure which video you’re exactly referring to in the given post but doesn’t matter. To achieve the analysis/results, firstly designing the data model properly is always of utmost paramount importance and than the context entered into the DAX while writing the measures played a pivotal role. If your model is correctly designed but the context entered into the DAX measure is not correct than one cannot blame the design of the model. So it goes two ways.

But yes, as I said you should combine the two tables of products and merge them into one.

Note: The videos are designed from the educational perspective and to provide the insights about how one show the analysis in Power BI so once the concept is understood than we can always write and modify the DAX measures into our models as per the requirements and achieve the analysis/results.

Hoping you find this useful. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

2 Likes
5

Hi @Thimios, did the response provided by the users and experts help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

6

Hi @Thimios, we’ve noticed that no response has been received from you since the 19th of February. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

7

Hi @Thimios, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!