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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.