Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

CountRows where column A contains a string and column B = a string.

I have been driving myself crazy with this, and I've looked around and asked colleagues and I can't seem to get there. I am used to Power Apps syntax, but not DAX so I really need some help.    I h...
CONTAINS
Filter Multiple Column
stevedep's avatar
stevedep
Icon for Memorable Member rankMemorable Member
6 years ago

Perhaps with AND(CONTAINSSTRING () ; CONTAINSSTRING ())

 

In the brackets you add your logic.

Kind regards Steve

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for this, unfortunately it gives me the error "the expression contains multiple columns but only a single column can be used in a True/False expression that is used as a table filter expression"