Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

add column with value based on filter

I have two tables OrderID  Date 1 13-okt 2 14-okt   OrderID  OrderLine  Product  Price 1 1 A 5 1 2 B 4 2 1 A 5 2 2 B 4 2 3 C 2   I want to a...
Need Help
  • manikumar34's avatar
    manikumar34
    5 years ago

    Anonymous , 

     

    Use something like this with relatioship.

     

    Column = CALCULATE(DISTINCT('Table (4)'[Product ]),FILTER('Table (4)','Table (4)'[Price]=MAX('Table (4)'[Price])))
     
    You can use the above DAX on both Calculated column or Measure. 
     
    Regards, 
    Manikumar
     
    If you think tjis is helpful, please Accept as Solution and leave a like.
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You can not create a column that uses slicer value. Think how can you use measure in place of that

 

 

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.