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.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

 

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

Anonymous 

i tried to change the query to page

 

the measure can also display the data that domain 1 is not blank.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi ryan_mayu , you are right, but the if the purpose is to see the "by page" performance on All domains for those Query got impressions in domain1, that will be different.

     

    That is saying, if change "Query" to "Page", while Measure is also applied, the number in domain0 and domain1, domain2 shall be same to "Query".

     

     

    In another word, the following left-hand chart is applied Measure, which is correct at all.

    But, when I replace the "Query" by "Day", as you can see on the right-hand table, it gives ALL result - the Measure is also applied in the right-hand table.

     

     

    So, is there a way can make the Measure or any type of filter can be applyed?

    Thank you.

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      4 years ago

      Anonymous 

      you can try to create a column

      scope = 
VAR _domain=maxx(FILTER(Raw,Raw[Query]=EARLIER(Raw[Query])&&Raw[Domian]="domain1"),Raw[Domian])
return if(Raw[Domian]="domain1","Y",if(_domain<>"","Y","N"))

      and add that column to filter.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi ryan_mayu , thanks again for your reply. Unfortunately, seems this is still different to expected result.

        Afte apply the column, if there is no date selection nor not change the Row to Page, it's fine.

        But let's say if I choose only 2 days in "Date", the result is like left-hand table.

        As you can see, the rows and numbers marked with red "x" shall not be included as they get no data in domain1. - the right-hand table is the expect result.

         

         

        Anyway, I appreciate your input, and if there is further ideas, please help to post.

        Have a joyful day.

        H