excel - How to change a attribute to a measure with DAX? -

I have too much data in my database and I want to display it as a pivot table using power pivot I am, however, some are text of my data (some flags, month names, names, last names, etc.). Is there any way that I can measure these properties so that the effect of my pivot table is not affected overall?

I have some ideas but nothing is yet clear, here is a sample of my table user id. Name | LName | City | State | Quantity 1111 John Smith 2 6 45 9 49 11 11 Alex Cash 6 2 31232 1113 Rob Adams 5 1 12434

I need to use these features when I am looking at data at user-end level (if I see the data City, State Leven, Matt not because I do not care about names / last names) Can I evaluate a reference and make the name a measurement?

something like (UserID, DisplayLlastName, BLANK ())

(A new idea that checks whether I use UserID If I display the last name, if not, then show the blank)

Any thoughts?

Thank you,

Oh, well it seems to me that I (<[User ID]), value (description [LNNAM]), BLANK ())

As long as UserID is on the Pivot table, the LName measurement will work.