You might be using COUNTD or COUNT when using it as Dimension.
Dimensions are used to categorize data in the data base - measures are the actual values that can be aggregated
I did something for some one else earlier and used this formula
I made a copy of the formula and converted it to a dimension
it will return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.