Forum Discussion

jerryr125's avatar
jerryr125
Icon for Helper IV rankHelper IV
2 years ago
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 displ...
  • Kaviraj11's avatar
    2 years ago

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