BrettOlbrys1
Board Regular
- Joined
- May 1, 2018
- Messages
- 139
- Office Version
- 365
- Platform
- Windows
In POWERBI, I have an ACTIVATIONS table. ACTIVATIONS has an ACCOUNT column (column A), a SEGMENT column (column B), and a QTY column (column C). There are 500,000+ rows of data.
Let's use this example:
In column A (ACCOUNT), I have these 20 rows of data: A, B, C, D, E, F, G, H, I, J, A, B, C, D, E, F, G, H, I, J.
In column B (SEGMENT), I have these 20 rows of data: ENT, GOV, SMB, ENT, GOV, SMB, STA, ENT, GOV, SMB, STA, OTH, SMB, ENT, GOV, SMB, STA, OTH, GOV, SMB.
In column C (QTY), I have these 20 rows of data: 79, 181, 92, 200, 40, 80, 7, 223, 300, 98, 42, 240, 100, 11, 38, 90, 200, 179, 61, 200.
If I create a TOP10 table visual with ACCOUNT (column A) and QTY (column C), I get the following result in my table visual:
The first column is B, H, I, J, D, G, C, F, A, E.
The second column is 421, 402, 361, 298, 211, 207, 192, 170, 121, 78.
The result is correct because it lists the quantity from greatest to least for the accounts and only shows ten rows of data.
But, if I introduce the SEGMENT column into my table visual, the TOP10 table now shows the following:
The first column is I, J, B, H, D, G, C, B, H, F, A, E, A.
The second column is 361, 298, 240, 223, 211, 207, 192, 181, 179, 170, 79, 78, 42.
The third column is GOV, SMB, OTH, ENT, ENT, STA, SMB, GOV, OTH, SMB, ENT, GOV, STA.
Instead of 10 rows of data, I now have 13 rows because if an ACCOUNT from column A had two different values from the SEGMENT column (column C), the visual included both rows.
I only want the top 10 rows of data, even if a row is split. So, in the above example, my result should be:
The first column is I, J, B, H, D, G, C, B, H, F.
The second column is 361, 298, 240, 223, 211, 207, 192, 181, 179, 170.
The third column is GOV, SMB, OTH, ENT, ENT, STA, SMB, GOV, OTH, SMB.
How do I get a table visual with ONLY 10 ROWS of DATA?
Let's use this example:
In column A (ACCOUNT), I have these 20 rows of data: A, B, C, D, E, F, G, H, I, J, A, B, C, D, E, F, G, H, I, J.
In column B (SEGMENT), I have these 20 rows of data: ENT, GOV, SMB, ENT, GOV, SMB, STA, ENT, GOV, SMB, STA, OTH, SMB, ENT, GOV, SMB, STA, OTH, GOV, SMB.
In column C (QTY), I have these 20 rows of data: 79, 181, 92, 200, 40, 80, 7, 223, 300, 98, 42, 240, 100, 11, 38, 90, 200, 179, 61, 200.
If I create a TOP10 table visual with ACCOUNT (column A) and QTY (column C), I get the following result in my table visual:
The first column is B, H, I, J, D, G, C, F, A, E.
The second column is 421, 402, 361, 298, 211, 207, 192, 170, 121, 78.
The result is correct because it lists the quantity from greatest to least for the accounts and only shows ten rows of data.
But, if I introduce the SEGMENT column into my table visual, the TOP10 table now shows the following:
The first column is I, J, B, H, D, G, C, B, H, F, A, E, A.
The second column is 361, 298, 240, 223, 211, 207, 192, 181, 179, 170, 79, 78, 42.
The third column is GOV, SMB, OTH, ENT, ENT, STA, SMB, GOV, OTH, SMB, ENT, GOV, STA.
Instead of 10 rows of data, I now have 13 rows because if an ACCOUNT from column A had two different values from the SEGMENT column (column C), the visual included both rows.
I only want the top 10 rows of data, even if a row is split. So, in the above example, my result should be:
The first column is I, J, B, H, D, G, C, B, H, F.
The second column is 361, 298, 240, 223, 211, 207, 192, 181, 179, 170.
The third column is GOV, SMB, OTH, ENT, ENT, STA, SMB, GOV, OTH, SMB.
How do I get a table visual with ONLY 10 ROWS of DATA?