Forum Discussion
Solved
Help with single value cannot be determined error
Hi I am new to Power Bi and hope someone can help I have two tables with stock qty's from two different warehouses which I would like to match if they don't match I would like to subtract UAE Qty ...
Use an appropriate aggregation function like MAX(AU[Qty]) or similar.
Hi REIProcess
It is happy that you can solve the problem , you can share your solution so that more user can refer to. and if your problem has been solved, you can accept your answer as a solution.
Best Regards!
Yolo Zhu
Hi Yolo
I am not 100% sure why it is working now.
I was preparing a .pbix file stripped of all other data not relivent to my issue to post here for help and suddenly the recommended "aggregation function MAX(AU[Qty])" worked perfectly in the stripped file. Sorry cannot understand what differnce might be between the two .pbix files but working now.
Thanks