Forum Discussion
Counting function in calculated column instead of measure
Hello There, Is it possible to use 'CountDistinct' function or any alternate way to count number of unique entries in a calculated column. I mean in 'New Column' instead of 'New Measure' Tha...
ianbarker
Helper III
Helper IIIDo you have an example of what you wish to acheive?
column = distinctcount(Dimcustomer[CustomerRank])
instead of
Measure = distinctcount(Dimcustomer[CustomerRank])
- ianbarker
I still don't follow why you would want to do that.
There's nothing to stop you doing it, but you'd end up with the same value against each record.
buddy actually i need total of the count column.
I have a calculation like 'Column/total count'
for this um trying to create a column with count and then its total as total count and then i will perform the above calculation.
um unable to create a calculation using both measure and column cus um in DirectQuery mode.
Is it clear now or u want me to elaborate it bit more..??
if it is clear then is there any better way to do that...!!