Forum Discussion
Filter or Slicer: include data for text contained in specific value
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.
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.
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.
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
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?
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:
query domain page value date a 0 c 100 1-Jan a 1 c 100 1-Jan a 2 d 100 1-Jan b 0 d 300 1-Jan b 2 d 500 1-Jan a 1 c 100 2-Jan a 2 d 100 2-Jan a 2 c 100 3-Jan b 0 c 100 3-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