Assume a table structure
Table A
col-1 col-2
1 2
2 1
3 2
3 2
Now i want a dimension/measure that can give me unique values of col1 and col2 combined.
can way i can do it ?
hi Aggarwal,
So to combine the fields you can concatenate the columns (this only works on strings, so we need to cast them to strings too)
STR([Col -1])+' '+STR([Col - 2])
we can then take a COUNTD of this new field...or just combine the whole thing into one formula
COUNTD(STR([Col -1])+' '+STR([Col - 2]))
Let me know if that doesn't make sense, or doesn't solve you issue.