DAX measure to show text when true

Hi,

I have a two column table from which I have a pivot, I have dropped Name into rows and Item into column and then Item again into values
which I have formatted as custom; "text"; "";"";"" , which give the result wanted but I would like a DAX measure to do the same;

I have tried

Please Login or Register  to view this content.

, which give the items as text when used in pivot table , but then a second measure ;

Please Login or Register  to view this content.

Which works but this seems a long way round having two measures so my question is is there a better way to achieve this?

I have attached book with both versions and source, which was first loaded to p query.

Richard.

There are lots of ways you could do it. You could just use:

="Item"

For the same reason that you don’t get 0 in all the blank cells in your first pivot. There is no data in the context of those cells so they return blank.