Forum Discussion
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 following:
Create a visual table or matrix, if there is a record of the Query in domain1, include the query and display the result of the Query in 3 domains.
Data:
Expect Result:
As you can see, since highlighted terms are in domain1, then only display those terms and their result in 3 domains.
For the rest query, don't display and don't include them in any of calculation / counting such as Total.
Expected Result shall look like:
Thanks in advance for your inputs.
Have a good day.
H
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.
15 Replies
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
you are welcome
Hi ryan_mayu , there is an "issue".
It can only be used when "Query" field is in the table.
If I change the "Row" to other fields, the Measure will not work any more.
Is there a way to make it?
Thanks again.
H
Anonymous
i tried to change the query to page
the measure can also display the data that domain 1 is not blank.