Forum Discussion
Selecting all rows from document where one row fullfils the criteria
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!
1 Reply
Eric_ZhangMicrosoft Employee
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!
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.