Forum Discussion
AnnaFenton
8 years agoFrequent Visitor
SUM
Hello, I find it odd that when I use the fomula: Total of Initial & Ext = SUM('DAC datasource'[Initial Total])+SUM('DAC datasource'[Ext Increase]) The total shows : Then I take SUM off : ...
- 7 years ago
Hi AnnaFenton
Power BI removes duplicate rows from a table visual by default. This is due to Power BI being a aggragation tool. You may refer to below picture.
You may try to add index column to provide the uniqueness of rows.
Regards,
Cherie
v-cherch-msft
7 years agoMicrosoft Employee
Hi AnnaFenton
Power BI removes duplicate rows from a table visual by default. This is due to Power BI being a aggragation tool. You may refer to below picture.
You may try to add index column to provide the uniqueness of rows.
Regards,
Cherie