Forum Discussion

Muttagoss's avatar
Muttagoss
Frequent Visitor
3 years ago
Solved

Update Measure to all material number

Am not able to update measure to all respective materials. In below example i want to update Price2 with $20 to all respective Materials. 

 

Sales OrgSold ToDivisionMaterialPrice1Price2
XXX12311Sugar$20 
XXX45622Sugar  
XXX78933Sugar  

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Muttagoss , Based on what I got

     

    calculate(firstnonblankvalue([Material], max(Table[Price1])) , filter(allselected(Table), Table[Material] = max(Table[Material] ) ) )

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Muttagoss , Based on what I got

     

    calculate(firstnonblankvalue([Material], max(Table[Price1])) , filter(allselected(Table), Table[Material] = max(Table[Material] ) ) )