Forum Discussion
jerryr125
Helper IV
2 years agoDisplay 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...
- 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 !!
Kaviraj11
Solution Sage
2 years agoHi
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 !!