Forum Discussion

KPME's avatar
KPME
New Member
3 years ago
Solved

Filter Column based on two string options

Hello everyone,   for one string filter the following works:  NewColumn = CALCULATE(DISTINCTCOUNT(table[ID]),FILTER(table,CONTAINSSTRING(table[OPTIONS],"String01")))   However for two strings ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hii,

    Does this work?

    NewColumn = CALCULATE(DISTINCTCOUNT(table[ID]),FILTER(table,CONTAINSSTRING(table[OPTIONS],"String01")||CONTAINSSTRING(table[OPTIONS],"String02")))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hii,

Does this work?

NewColumn = CALCULATE(DISTINCTCOUNT(table[ID]),FILTER(table,CONTAINSSTRING(table[OPTIONS],"String01")||CONTAINSSTRING(table[OPTIONS],"String02")))

Hope this helps.