Selecting all rows from document where one row fullfils the criteria

[jvu]

Hi,

I have a general ledger material which looks following.

Document number	Line number within document	Amount	GL account number	Account name
1	1	-10.00	30	Sales
1	2	5.00	25	AR
1	3	5.00	22	VAT
2	1	8.00	25	AR
2	2	-4.00	30	Sales
2	3	-4.00	30	Sales
3	1	-3.00	30	Sales
3	2	3.00	35	AR

What I would like to do is select account "Sales" from a filter for example and then see all rows from documents that include postings to selected sales account.  Currently I will only see the lines that are actually posted to sales account but not the other lines of the document. Am I able to do this in Power BI? In Qlikview this can be done by using button with action to select all lines fulfilling the criteria.

Thanks!

[Eric_Zhang]

---

@jvu wrote:

Hi,

I have a general ledger material which looks following.

Document number	Line number within document	Amount	GL account number	Account name
1	1	-10.00	30	Sales
1	2	5.00	25	AR
1	3	5.00	22	VAT
2	1	8.00	25	AR
2	2	-4.00	30	Sales
2	3	-4.00	30	Sales
3	1	-3.00	30	Sales
3	2	3.00	35	AR

What I would like to do is select account "Sales" from a filter for example and then see all rows from documents that include postings to selected sales account.  Currently I will only see the lines that are actually posted to sales account but not the other lines of the document. Am I able to do this in Power BI? In Qlikview this can be done by using button with action to select all lines fulfilling the criteria.

Thanks!

---

@jvu

Your question is not quite clear for me, do you mean that, say if "Sales" is selected, supposing that the correlated column "Document number" is 1, the show all the rows which have "Document number"=1? If so, you can simply do that with two slicers, just diable the interaction between the first slicer and table visual.