Forum Discussion

AnnaFenton's avatar
AnnaFenton
Frequent Visitor
8 years ago
Solved

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 : ...
  • v-cherch-msft's avatar
    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