How to calculate results filtered on the many side? (Many to One Relationship)

[cdawidow]

Hi guys, I have 2 tables one is a product table (PRD PC) and the other is my Sales Fact Table where I have my customer names.  Essentially, I want to calculate cumualtive sales of product lines filtered by a selected customer name.  I have cumulative totals and cumulative % as calculated columns in my product table (PRD PC) but as you can see below, I do not get the correc tinformation.  It gathers the total (ALL) amount of the specific product line and does not filter based on my selected customer.  What is the best way that can allow me to fix this issue?

[Greg_Deckler]

@cdawidow Sorry, having trouble following, can you post sample data as text and expected output?

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[amitchandak]

@cdawidow , can you share the formula?

[cdawidow]

Hey, I am not using a formula, I am simply selecting the columns from the ONE side table and matching it by customer name which is found from the many side

[amitchandak]

@cdawidow , I was checking for cumulative

It needs to use all selected

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(Table),Table[product] <=max(Table[product])))

or

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(Table),Table[product] <=max(Table[product]) && Table[customer] =max(Table[customer]) ))

or

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(product),product[product] <=max(product[product]))
,filter(allselected(customer),customer[customer] =max(customer[customer])))