Dynamic Segmentation - additional dimensions

DAX DAX Calculations
1

Hello Experts again,

I posted another question earlier but want to simply my question.

I have followed Sam’s dynamic segmentation video and it works great. I had to modify a little bit for my situation.

My question is: If I add more dimensions in the table then I get wrong result.

For e.g.:

Correct Result :

image

Formula:

image

Where 'Medallion Groups" is my disconnected table.

image

But If I add one more dimension : “Prd_Line_Desc” then I lose data, the three rows doesn’t add up to result. This is because the formula has > 2500 filter. How do I make the formula so it works for all the scenerios?

image

Thanks,
-RK

2

Hi @rit372002, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster.

  • Include the masked demo pbix file.

Not adhering to it may sometimes cause delay in getting an answer.

Please also check the How To Mask Sensitive Data thread for some tips on how to mask your pbix file.

Here are some videos that may help you masking sensitive data and create datasets and data models representative of your problem:

3

Hi @rit372002, we’ve noticed that no response has been received from you since yesterday.

We are waiting for the masked demo pbix file and any other supporting links and details.

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

4

Thanks. Here is the pbix. Basically I needed correct filters to make it work.

https://drive.google.com/file/d/1wPvl8XlgPHIY7LY3bnd0aEQ0_hieCKaf/view?usp=sharing

Thanks for your help.
-RK

5

Thank you for sending the PBIX. Bumping this post for more visibility.

6

Hi @rit372002 , correction

As you already mentioned , the individual lines does not add up to the totals, also not in my model !
Challenge.

7

Hello everyone. Bumping this post again for more visibility.

8

Hi @rit372002! We noticed that your inquiry was left unsolved for quite some time now.

We strive to answer ALL inquiries in the forum.

However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectivelyand still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!