DAX containsrow function

[dicken]

Hi,
Can someone help with Containsow and contains for that matter.

I have a table in Power pivot the in consist of 3 column Item , Unit and Product ,
the top row is A , 3 , X

so if I write a measure ;

CONTAINSROW( Table2, "A", "3", "X" )

why do I get an error, it asked for a table, = Table2 and
then I give a single value for each of the columns of that table, so why the error?

Another example

ContainM:=VAR containV  = CONTAINS( Table2, Table2[Item] ,"C", Table2[Prodiuct] , "Z" ) 
RETURN
CALCULATE( COUNTROWS( Table2), FILTER( ALL(Table2[Prodiuct]),  containV  ))

This return 22 even though there are only two rows of Table2 that would give a TRUE to the contains ?
I was expecting a the same as ;

CALCULATE( COUNTROWS( Table2), FILTER( ALL( Table2[Prodiuct], Table2[Item]) , Table2[Item] = "C" && Table2[Prodiuct] = "Z" ))

Richard.

 

[Matt Allington]

I’ve never used the function, but my best guess is column 2 is numeric and should not be in quotes.

 

[RoryA]

CALCULATE( COUNTROWS( Table2), FILTER( ALL(Table2[Prodiuct]), containV ))

You are passing one True/False value to the filter here, so it's the same for all rows of the table.

 

[dicken]

You are passing one True/False value to the filter here, so it's the same for all rows of the table.

Of all the DAX functions I find CONTAINS , CONTAINSROW and IN the most confusing, so times I get just what I want
when tested and checked against the source, other times not, it's one I'm wary of using.
Richard.

 

[RoryA]

I'm not sure what is confusing you. They just return a True/False value depending on whether the table contains a row that matches the values specified. IN is basically just a shorthand form of CONTAINSROW

 

[dicken]

I'm not sure what is confusing you. They just return a True/False value depending on whether the table contains a row that matches the values specified. IN is basically just a shorthand form of CONTAINSROW

I'm not sure what is confusing you. They just return a True/False value depending on whether the table contains a row that matches the values specified. IN is basically just a shorthand form of CONTAINSROW

It's when I try to use with filter, also that ' Contians, Containsrwo and IN' all seem to have a different syntax order,