Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Formula

hi experts, 

 

Having trouble to creat a meature to match a vlaue

 

newcmeaure = Tablename[columnname] = 'Agreed'

I ma haviung trouble to get the syntax right, urgent thanks 

 

 

 

 

 

Need Help
  • richbenmintz's avatar
    richbenmintz
    7 years ago

    Hi Anonymous,

     

    Sorry not sure what you are trying to accomplish with this measure, a measure that calculates a value would look something like:

    measure = Calculate(sum('table'[column]), 'table'[column] = "value")

5 Replies

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    7 years ago

    Hi Anonymous,

     

    Are you able to provide a sample pbix file, not sure I understand your requirement and the data generally makes things clearer

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      hi thnaks for your reply I managed to figure it out , it was a wrong descriptuon , sorry but I am having trouble now to get the right syntax for my new meaure , I appriciate any help

      I cant get this right 

      newmeaure = (tablename[columnname] = 'Agreed'

      • richbenmintz's avatar
        richbenmintz
        Resident Rockstar
        7 years ago

        Hi Anonymous,

         

        Sorry not sure what you are trying to accomplish with this measure, a measure that calculates a value would look something like:

        measure = Calculate(sum('table'[column]), 'table'[column] = "value")