I have a data table that contains identical rows, and I want to display every single row in a table chart, exactly as it appears in the data model. the chart only displays three rows instead of the four I expect.
@Chanty4u's suggestion is entirely correct, if you want to see duplicate rows, but your question suggests an issue you may be missing.
In that table the first three columns should be Dimensions, but the third should be a Measure, as it is a numeric value. The Measure can be created with drag and drop or be typed in, and it simply needs to be sum(SalesAmount).
If you do this you will still get three rows, but you will have the correct total of 2,400 for that row. If you want to see that this was two laptops and not just one, you can use @Chanty4u's solution, or if you want to see it is two rows you can add a counter to the table in the load:
LOAD 1 as LineCount, OrderID, Product, Region, SalesAmount FROM YourSource;
You can then add another measure of sum(LineCount) to show that there were two laptops sold.
The advantage of using measures (apart from the big one that duplicates can get removed) is that you also get totals for those columns.
@Chanty4u's suggestion is entirely correct, if you want to see duplicate rows, but your question suggests an issue you may be missing.
In that table the first three columns should be Dimensions, but the third should be a Measure, as it is a numeric value. The Measure can be created with drag and drop or be typed in, and it simply needs to be sum(SalesAmount).
If you do this you will still get three rows, but you will have the correct total of 2,400 for that row. If you want to see that this was two laptops and not just one, you can use @Chanty4u's solution, or if you want to see it is two rows you can add a counter to the table in the load:
LOAD 1 as LineCount, OrderID, Product, Region, SalesAmount FROM YourSource;
You can then add another measure of sum(LineCount) to show that there were two laptops sold.
The advantage of using measures (apart from the big one that duplicates can get removed) is that you also get totals for those columns.
