Forum Discussion

MartinParmen's avatar
MartinParmen
New Member
3 years ago

Calculated field does not have the same result on Service and pivot table

Hello. I made a calculated field in Power BI (desktop and service). It sums a volume and then rounds it to the nearest hundred. Then, in Excel, I take this dataset in order to build a pivot table. When I put this calculated field in "Value", I don't get rounded values but real values instead. Why ? Have you got an explanation ? I would have like rounded values.

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    MartinParmen How are you rounding? Using the ROUND function or via the configuration of setting the number of decimal places?

    • MartinParmen's avatar
      MartinParmen
      New Member
      3 years ago

      Greg_Deckler. Thanks to your answer, I went deeper in Power BI Desktop. In fact, "Volume" is not rounded ! It is just a simple DAX function Sum([Volume]). But, I use this function in another one with Calculate and some filters AND the ROUNDUP function. Ok. Fine for me.

       

      So, in Excel Pivot table, I switch to this calculated function but it gives me 0. Is it because specifics filters in the calculated dax function ?