Forum Discussion
Solved
Display text instead of the sum
Hi -
I have a table visualization.
Example:
| Department | Counter Sales |
| 1234 | 25 |
| 5678 | 0 |
| 91011 | 0 |
| 1213 | 100 |
instead of displaying the 'sum of sales', I would like to display "Yes" or "No". That is, if the counter of the field sales is greater than 0, then display "Yes" else display "No"
Example:
Example:
| Department | Counter Sales |
| 1234 | Yes |
| 5678 | No |
| 91011 | No |
| 1213 | Yes |
Any thoughts ? Jerry
Hi
Use the following DAX formula to create the measure:
Sales Status Measure = IF(SUM('Sales'[Counter Sales]) > 0, "Yes", "No")Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
1 Reply
Hi
Use the following DAX formula to create the measure:
Sales Status Measure = IF(SUM('Sales'[Counter Sales]) > 0, "Yes", "No")Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!