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 All,
I have tried to use the following meausre to output the number of times the word "Faulty" appears in a column within my table but have probly used the wrong type of measure to do this, if anyone can help or point me in the right direction?
Product ID | Faulty/Non Faulty |
1 | Faulty |
2 | Non-Faulty |
3 | Non-Faulty |
4 | Faulty |
5 | Faulty |
6 | Faulty |
7 | Faulty |
8 | Non-Faulty |
9 | Faulty |
10 | Faulty |
TIA
Solved! Go to Solution.
HI @UK_User123456,
I tried to replicate your query so got expected result. Please see the below screen shot attached.
As per my observation there is some changes required in your formula. The green font changes should be done at your end. As you are using some different column for filtering. As per your data there are only 2 columns Product ID and Faulty/Non-Faulty.
Please give Kudos to this effort and mark it as a solution if it helps you!
HI @UK_User123456,
I tried to replicate your query so got expected result. Please see the below screen shot attached.
As per my observation there is some changes required in your formula. The green font changes should be done at your end. As you are using some different column for filtering. As per your data there are only 2 columns Product ID and Faulty/Non-Faulty.
Please give Kudos to this effort and mark it as a solution if it helps you!
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |