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 Org Sold To Division Material Price1 Price...
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] ) ) )

Muttagoss's avatar
Muttagoss
Frequent Visitor
3 years ago

Thanks Amit. This solution is very helpful.