Showing results for 
Search instead for 
Did you mean: 

Calculated columns incorrectly displayed in the data view in when filtered differently

I'm in a data view and am inspecting the data in 2 calculated columns.

If i filter the whole table to show me only 1 particular order (9437264) i see the correct (expected results) in the calculated columns. This is the data extract to excel:


However, if i remove the filter on the order and apply a filter on another column, then the data is incorrect. Oddly enough, i see the correct number for another order (9427759). 

Excel extract:




AFAIK, the calculated columns are not re-calculated on filtering in the data view. 

Thank you in advance.

Status: Needs Info

Hi @vovcha,


Please share pbix file with us if possible. 


Best Regards,
Qiuyun Yu 

Status changed to: Needs Info