Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter or Slicer: include data for text contained in specific value

Hello everyone,   There is a column called "Domains", "Query" are those user searching terms,  here is the sample file to download.   Is there a way to set slicer or filter to include data as f...
Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anonymous 

    I think the second solution meets your request. you can take a look. Just the layout is slightly different from your screenshot since we can't remove subtotal and only display total.

     

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

Anonymous 

you can try to create a measure and add that measure to filter.

Measure = if(ISBLANK(sumx(FILTER(Raw,Raw[Domian]="domain1"),Raw[Impressions])),"NO","Yes")

pls see the attachment below

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Just tried in the actual data, it does work well.

Thank you!

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    you are welcome