Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I have a table one column has Comments (free text) and another column has a value. I'm trying to count the rows that contain the "Warranty" in any part of the text in Comments column and in the Totals column the value 0
eg
[Comments] [ Total]
Checked engine $500
Service may have warranty $100
Warranty repair $0
Im looking for a solution of 1 which is the 3rd row as it has the word warranty and the value 0
Thanks in advance
Hello - thanks for your response but the dax formula summed the value i.e. I got a result of $481.80 which was the value of 1 invoice which had the term warranty in the [comments] - I did a manual check and there were 3 invices with the term warranty 2 had values and 1 had $0.00. the solution should give a result of 1 i.e. 1 row which has $0.00 value and the term warranty
I'm new to DAX
Thanks once again very much appreciated
@gctaeger , based on what I got. Try a measure like
calculate(sum(table[total]), filter(Table, search("warranty",[Comments],,0)>0))
User | Count |
---|---|
53 | |
35 | |
20 | |
16 | |
15 |
User | Count |
---|---|
94 | |
72 | |
30 | |
22 | |
16 |