Forum Discussion
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
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")
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'
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")Thanks for quick respond , new in DAX and I hope I can use your experties more :)
Anonymous,
You may also take a look at https://www.sqlbi.com/articles/filter-arguments-in-calculate/.
