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])

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi AZL

Assume you have the result as below

Per your requirement, you could create a measure

Measure = CALCULATE(DISTINCTCOUNT(Sheet3[col1]),ALLEXCEPT(Sheet3,Sheet3[col2]))

 

 

Best Regards

Maggie