I have a measure that is a sql varchar(24) that has a mix of alphanumeric and numeric characters. In fact it is a UID.
But in Edit mode of the cube, Distinct Count is not an option (for any text field I guess). Is there another way? Maybe a calculated member?
Thank you!!!!!!!!!!!!!