Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Getting different totals for Count and Distinct Count which is not grouped by Function prop

Hi, I expecting a solution for the following     On the left, the total 64 is the sum of the item title. On the right the measure is the distinct count of the item title.  While analysing i...
Data Protection
junaise7682's avatar
junaise7682
Frequent Visitor
5 years ago

As per my understanding, you need to count the distinct row count the rows 
you can use the function 

Count = COUNTROWS(Table1)
It will get you the 64 in Jun, 
just an example with employees name.