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).
AFAIK, the calculated columns are not re-calculated on filtering in the data view.
Thank you in advance.
Please share pbix file with us if possible.
Best Regards,Qiuyun Yu