Forum Discussion
Help with single value cannot be determined error
- 1 year ago
Use an appropriate aggregation function like MAX(AU[Qty]) or similar.
Use an appropriate aggregation function like MAX(AU[Qty]) or similar.
- REIProcess1 year agoRegular Visitor
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.
- lbendlin1 year agoSuper User
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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- REIProcess1 year agoRegular Visitor
Thanks for your help, got it to work somehow. Thanks