Forum Discussion
Sum of Distinct Count by column
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])
Community ChampionYou 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])
I am surprised how fast you replied.
Thank you so much!
So how would you filter out a distict value?
So in the example above how would you say return the distinct values = SPRING15
Thanks , this helped me.
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
