Forum Discussion
DAX Count Filtering where a column contains text from another Table's Column
Hello I need to create a meassure that counts the items in a column filtering if the column contains a text from another table's column, I'll explain. Table1: ID Product 1 Apple, Banana,...
AlB
Community Champion
Community Champion
You sure you're doing it as described? I get exactly the results you show in your first post
Hello AlB
I tried with the frutis scenario and it worked but in production it didnt work.
I have the following DAX, the only differece with yours are the ";" which were not recognized and I changed them to ","
CountProducto =
COUNTROWS (
FILTER (
visitas,
CONTAINSSTRING (visitas[Product],SELECTEDVALUE(UCVisitas_ProductoServicio[Title]))
)
)
Here is a pic of the info that is not working correctly:
A = The result, as you can see, there es an empty "product".
B = The count of the products (without the filter) where you can see an example of the mixed products (line 3).
C = The products catalog.
What I noticed is the result in production also gives me an empty "Category" (A).
Thank you for your help.
