count amount of different values of combined dimension

[#1]

Hi com,

sorry for this Header! my english is by far not the best and i don't know how to keep this short.

I have a Dimension that combines two table coloumns. And i want to know how many different value versions there are for this combined dimension.

so for example we have:

typ     name

1          a

2          e

3          c

4          b

4          b

so in a combined dimension we would have 4 bar's. In my case there are so many that i cant count them hand by hand.

Can someone help me or has advices.

Thanks in advance

-Eric

[sunny_talwar · Accepted solution]

You want to count distinct combination of typ and name?

May be this:

Count(DISTINCT typ&name)

[#3]

great and fast solution!! thanks once again!

great see u hitting 100.000!!