cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ritesh_Air
Post Patron
Post Patron

Context - Dynamic Segmentation

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

1 REPLY 1
v-xiaotang
Community Support
Community Support

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.

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!