Help with single value cannot be determined error

[REIProcess]

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 from AU Qty from each warehouse and see the outcome for each separate line in new column comment which I have created. 

Image below showing my issue 

Hope someone can give me some help as I am a bit confused with error message 

Thanks 

[lbendlin · Accepted solution]

Use an appropriate aggregation function like MAX(AU[Qty])  or similar.

[REIProcess]

Hi thanks for reply. I tried that but its not giving me what I need. 

Below Diff column is outcome with this aggregation. Don't think any of the DAX functions will do what I need here.

All I need it to do is highligh difference between Au_Qty & UAE_Qty as highlighted below.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[REIProcess]

Thanks for your help, got it to work somehow. Thanks 

[v-xinruzhu-msft]

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

[REIProcess]

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