DAX Formula

[Anonymous]

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 

[richbenmintz]

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]

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 · Accepted solution]

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")

[Anonymous]

Thanks for quick respond , new in DAX and I hope I can use your experties more 🙂

[v-chuncz-msft]

@Anonymous,

You may also take a look at https://www.sqlbi.com/articles/filter-arguments-in-calculate/.