Forum Discussion

fbron's avatar
fbron
Frequent Visitor
3 years ago

Lookupvalue doesnt return expected values

Table 1=  Sales Line Table with rows with a certain weigth. Table 2 = Warehouse Line table with a certain weight What I wat to do is create a column in my Sales Line Table (Table 1) containing the ...
Need Help
fbron's avatar
fbron
Frequent Visitor
3 years ago

Nishudhan, 

 

Thank you for the quick response. 

Unfortunately im in need for the column to be in the sales table. 

 

Basically what im looking for is that all the wieght from a certain Sales Line is represented in our warehous (warehouse line) the visuals Could be possible that theres no line available in the Warehouse Line Table\

amitchandak's avatar
amitchandak
Super User
3 years ago

fbron , A new column

sumx(filter(Warehouse,Warehouse[Combine] = sales[combine] ) , Warehouse[Weight])

 

or

 

Maxx(filter(Warehouse,Warehouse[Combine] = sales[combine] ) , Warehouse[Weight])

  • Nishudhan's avatar
    Nishudhan
    Frequent Visitor
    3 years ago

    amitchandak  

    Hi amit,

    The same will throw an error stating 

    "A single value for column 'combined' in table 'Warehouse_line' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result." 

    So it will not working as it is aggregating the result.