Forum Discussion

burak's avatar
burak
Frequent Visitor
10 years ago
Solved

Sum of Distinct Count by column

Hello Everyone,   I am having trouble calculating sum of Distinct Count. Basically, I would like to calculate Distinct count regarding a different column. Here is the example:   Term             ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    You could create a new column that concatenates Term and ID and then create a measure that does a DISTINCTCOUNT of that column. This measure should react appropriately to slicers and such. So:

     

    Column

    TermIDs =CONCATENATE([Term],[ID])

    Measure

    DistinctTermIDs = DISTINCTCOUNT([TermIDs])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

You could create a new column that concatenates Term and ID and then create a measure that does a DISTINCTCOUNT of that column. This measure should react appropriately to slicers and such. So:

 

Column

TermIDs =CONCATENATE([Term],[ID])

Measure

DistinctTermIDs = DISTINCTCOUNT([TermIDs])
vedran's avatar
vedran
Frequent Visitor
9 years ago

Hello, 

I would like to ask question as a continue of your answer, when we calculate a measure

DistinctTermIDs = DISTINCTCOUNT([TermIDs])

How to put this measure result in new column for every product (row). 

 

Example, we have as a product name

Spring15 

Spring15 

Spring16

 

And create DISTINCTCOUNT measure that we can manually filter and for Spring 15 Total will return 2.

How to put this value 2 in the same table, near each item?

 

Result should be

ProductName   No. (from measure)

Spring15           2

Spring15           2

Spring16           1

 

Thank you in advance