Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
v-qiuyu-msft
Community Support

Hi @vovcha,

 

Please share pbix file with us if possible. 

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Status changed to: Needs Info