Hi,
See example,
DAX formula returns TRUE when the context for ColumnName has been filtered down to one distinct value only.
no total = IF(HASONEVALUE(‘Table’[Month]);[Total Amount];BLANK())
Paul
2 Likes