Forum Discussion

AZL's avatar
AZL
Frequent Visitor
7 years ago
Solved

Sum the resultant values from Distinctcount function.

Hey All,   I deadly need your helps guys.   Let's say I have the following table:     I want firstly to distinct count the values in Col1 based on Col2 to get:   A1>>>2 B1>>>1 C1>>>1...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi AZL

     

    How about a DISTINCTCOUNT on the concatenation of the columns you are interested in? For instance, in your first example with Col1 and Col2, you create an additional calculated column

    Table1[NewColum]=Table1[Col] & Table1[Col2]

    and then

    DISTINCTCOUNT(Table1[NewColum])

AZL's avatar
AZL
Frequent Visitor
7 years ago

Hey AlB

 

That works like heaven to me!!

Thank you so much for your smart solution.

AlB's avatar
AlB
Community Champion
7 years ago

AZL

:smileyhappy: you're very welcome. glad it helped.

Please mark it as solution then, so that it's available for others too.

Cheers