I am using Sumx Function to calculate selective data in Power BI report using SUMX as a query in adding custom column. But It is showing error "Expression.Error: The name 'SUMX' wasn't recognized. Make sure it's spelled correctly". What is needed to be done in such case.
Sounds like the issue is trying to get dax to do everything in a single statement and over complicating the problem.
Firstly, are you able to join your two tables via the Asset column? If not, are you able to create a Unique Asset list (can be done within Power Query) that you can link both tables to instead? Once you get your data structure right, we can create a set of dax statements to break your formula into chunks and have Power BI run them appropriately.
Did I answer your question? Mark my post as a solution!