Filter total sales for categories that has products f

[Anonymous]

Hello,

I am trying to make a measure that shows the total sales for all products in all categories that have products in it from a specific manufacturer. So lets say i have a manufacturer that have products in categories 1,2,4 then i would like to have a measure that shows the sum of the total sales for all products in those 3 categories.

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

We can create a table and a both relationship to meet your requirement.

1. Create a summarize table.

Table 2 = SUMMARIZE('Table','Table'[categories],"Total",SUM('Table'[sales]))

2. Then create one to many relationship between them.

3. At last create a table visual like this,

If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?

It will be helpful if you can show us the exact expected result based on the tables.

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

Best regards,

Community Support Team _ zhenbw

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

BTW, pbix as attached.

[amitchandak]

@Anonymous , Try a measure like

measure =
var _sel = countx(allselcted(product[category]),product[category])
return
sumx(filter(summarize(product,product[product], "_1" , distinctcount(product[category]) , "_1", sum(sales[sales])),[_1]=_sel),[_2])