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

Question

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.

greg_deckler · Answer

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

martinparmen · Answer

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.&nbsp;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 ?

Forum Discussion

Related content

Gallery Terms of Service

Calculations with measures return odd results

Download cypher results

Calculating growth - result if prior year result is zero?

No results