Display text instead of the sum

[jerryr125]

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

[Kaviraj11 · Accepted solution]

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 !!