I am trying to add a text field into my Power Pivot table. To do this I created a measure and used the DAX formula:

=IF(COUNTROWS(VALUES(Table1[Field]))>1,BLANK(),VALUES(Table1[Field]))

This returns the right values for me BUT rows with only one value display that value in the subtotal. Is there a way around this? I know I could apply a conditional format formula but I would like to stay away from doing that and write it somewhere into the formula or something else I'm not thinking of.