Filter in DAX expression is incorrect

[TGB]

Hi everyone,

I'd like to count the number of products of a certain product-type that each customer (ID) ever has bought . For the analysis I need it to be in displayed in a column not a measure.

The following DAX expression counts the total number of products sold to a customer correct.

Total products = Calculate( COUNT(SalesProducts[ProductID]) , SalesProducts[CustID] = EARLIER(DataCustomers[CustID]))

However, after adding an extra filter (product type) the results are incorrect (too low).

Type Wielrennen =

var _WielrennenProducts = GROUPBY( FILTER( DataProducts , DataProducts[LabelSport] = "Wielrennen"), DataProducts[ProductID] )

return

Calculate( COUNT(SalesProducts[ProductID]) , SalesProducts[CustID] = EARLIER(DataCustomers[CustID]), _WielrennenProducts)

Type MTB =

var _MTBProducts = GROUPBY( FILTER( DataProducts , DataProducts[LabelSport] = "MTB"), DataProducts[ProductID] )

return

Calculate( COUNT(SalesProducts[ProductID]) , SalesProducts[CustID] = EARLIER(DataCustomers[CustID]), _MTBProducts)

Anyone an idea of how I should add the second filter: DataProducts[LabelSport] = "Wielrennen"

[Greg_Deckler · Accepted solution]

@TGB - 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.

[TGB]

Hi, 

I found the solution in one of the links. I made a mistake with linking the data.