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 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

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    Anonymous 

    Let's make your request be clear.

    1. you want to see all the queries that have domain 1 value.

    2. you will change the query to other column and you want to see the total amount keeps the same. What's more you only want to see the rows which have domain 1 value?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi ryan_mayu ,

       

      Thanks for your reply again.

      You are almost correct, the purpose is to have a slicer or a way to filter the stasted idea.

      Probably I will change the "Row"' from "Query" to "Page", or "Date".

       

      So in your 2nd screen cut in point 2, it will be:

      It's because Query "a" has record in domain1, so what is "a" 's resuslt in other domain? 300 in domain 2, but when breakdown to "Page", it's in page d.

       

      Same to Date: if adding Date info:

      querydomainpagevaluedate
      a0c1001-Jan
      a1c1001-Jan
      a2d1001-Jan
      b0d3001-Jan
      b2d5001-Jan
      a1c1002-Jan
      a2d1002-Jan
      a2c1003-Jan
      b0c1003-Jan

       

       

      The expect result is: (in 3-Jan, the "a" only get number in domain 2, but not in domain 1, as a result, the number shall not be included.

       

      So, I thought a way to filter and slicer might be better since all the rest of data calculation will be impacted, no matter how to breakdown, or change the dimension field.

       

      Appreciate your time and help.

      H

       

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        4 years ago

        Anonymous 

        I think the logics conflict.

        for page, you want to display d which domain 1 is empty.

        for date, you don't want to display 3-Jan which domain 1 is empty.

        i think you need to align the logics.

         

        Above is my own opinion. Since you have accepted the solution, I suggest you to open a new post and used the example you just proivded to see if any experts can provide you better solution. (It's because I think super users and community supporters seldom look the post which has a solution)