Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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/.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |