Context - Dynamic Segmentation

[Ritesh_Air]

Hi experts,

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

I am trying to understand the context piece. I always have difficulty getting my head wrapped around it. Here is the situation:

I have a parent_customer - 'Cooperative Farmers Elevator'.

It has bunch of growers - 'rpt_grp_key_unique'.

They buy different products which has catalyst points, shown in "With Products" tab. So I have got 20.3 million worth of sales amount and 1.5 million worth of catalyst points.

My quesiton is: I only want to have growers who have bought more than 2500 catalyst points worth of products.

I created "Growers Over 2500" tab based off of performance analyser to show which numbers I should see. In this situation, 15.1 million for sales amount and 1.1 million for catalyst points for only those growers who have more than 2500 points..

But I want to show this on "With Products" tab.

So long story short, I want to see 15.1 million and 1.15 million instead of 20.3 and 1.5 respectively on "With products" table.

I have put the sample pbix file on google drive.

Thanks in advance,

-RK

[v-xiaotang]

Hi @Ritesh_Air 

what's the difference of the two sheets With Products & Growers Over 2500 ? I mean which part of the data in sheet With Products  is more than that in Growers Over 2500, so we need to filter it out? so could you kindly tell us the filter requirements in order to solve the problem more efficiently.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.