Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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")
Proud to be a Super User!
Hi @Anonymous,
Are you able to provide a sample pbix file, not sure I understand your requirement and the data generally makes things clearer
Proud to be a Super User!
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")
Proud to be a Super User!
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/.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |