Forum Discussion
List & Sum filtered items
Hello,
May I have your help on this data question.
The raw data looks like following. Sample PBI file here.
There are several different "Domain" values, AIR, AIR1, air2.
Is there a way in Power BI to create a table (visual),
- To list the Query and sum their impressions or clicks those in one Domain but not in another?
e.g. Only in domain "AIR", but not in "AIR1
- Possible to breakdown by Page as well?
- (Plus:) Possible let user free to choose the filter domain? e.g. user can choose "In" domain(s) AND "not in" domain(s)
For example:
- List Query existing in AIR, but not in AIR1
- Sum Impressions which Query existing in AIR1, but not in AIR and not in AIR2
- Sum Impressions by Page which Query existing in air2, but not in AIR or not in AIR1
If not possible to give user freedom to choose, how to just create preset criteria to filter table (visual)?
e.g. I can create a table(visual) with preset lists Query in AIR but not in AIR1, create another table(Visual) list Query in AIR1 and AIR but not in air2
Thanks in advance & have a good day.
H
3 Replies
- BA_Pete
Super User
Hi Anonymous ,
Not sure f I'm oversimplifying this or misunderstanding your requirements but it just sounds like you need to use a slicer on your [Domain] field.
If you want to give the user better usability of the slicer then, under 'Selection controls', you can disable 'Multi-select with CTRL' and enable 'Show "Select all" option'.
Pete
Hi BA_Pete ,
Applying "Domain" into slicer will make the table list items under selected Domain only.
What we want to make is to list items only under one domain but not under another domain
For example:
As following Red highlighed items, they are in "AIR" domain ONLY, not in "AIR1" and "air2". This is what we want.
But if applying slicer "AIR", the table will list no item for AIR1, air2, AND contain ALL item under "AIR", but not "ONLY in AIR, not in AIR1, air2".
Thanks.
H
