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])
wharding's avatar
wharding
Regular Visitor
10 years ago

So how would you filter out a distict value?

 

So in the example above how would you say return the distinct values = SPRING15