Solved: Re: DAX Formula

Anonymous · ‎11-14-2018

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 · ‎11-14-2018

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

I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!

View solution in original post

richbenmintz · ‎11-14-2018

Hi @Anonymous,

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

I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!

Anonymous · ‎11-14-2018

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 · ‎11-14-2018

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

I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!

Anonymous · ‎11-14-2018

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

v-chuncz-msft · ‎11-14-2018

@Anonymous,

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.