Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 

 

 

 

 

 

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


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

5 REPLIES 5
richbenmintz
Solution Sage
Solution Sage

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
Not applicable

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


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
Not applicable

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/.

 

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.