Forum Discussion
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. Wh...
Greg_Deckler
Community Champion
Community ChampionMartinParmen How are you rounding? Using the ROUND function or via the configuration of setting the number of decimal places?
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 ?