cancel
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:

image.png

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:

 

image.png

 

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

Thank you in advance.

Status: Needs Info
Comments
Moderator

Hi @vovcha,

 

Please share pbix file with us if possible. 

 

Best Regards,
Qiuyun Yu 

Moderator
Status changed to: Needs Info