Forum Discussion

kasiaw29's avatar
kasiaw29
Resolver II
5 years ago
Solved

Getting the right value based on condition

Hi community,   I need your help with a little dax. I'm trying to get the right value based on the result from another column.  I have a table that generally summarizes project budgets, table has ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    kasiaw29 , Create a measure like

     

    measure = calculate(sum(Table[Value]), filter(Table,Table[ Version ID] = calculate(max(Table[Version ID]), allexpcept(Table,table[Project]))))

amitchandak's avatar
amitchandak
Super User
5 years ago

kasiaw29 , Create a measure like

 

measure = calculate(sum(Table[Value]), filter(Table,Table[ Version ID] = calculate(max(Table[Version ID]), allexpcept(Table,table[Project]))))

  • kasiaw29's avatar
    kasiaw29
    Resolver II
    5 years ago

    Hey,

     

    Thanks for this! I had to rank my version id's as apart from the ones that needed to be considered I had others as well that were not to be counterd, but your solution worked for me. 

     

    Thanks so much!