Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

count rows with some conditions

Hi everyone! I need to count the rows with same idticket, idclient after the first time that they appear. I also have to exclude duplicates so I only have to count once these records. The result is ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I know johnt75 , I didn't replace it. I used it as a filter. What I was trying to do is display the total for each client and the total for all in a table. That's why I said that if you tried to do with the calculated column the duplicates appear because they also have 1 in the condition.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You may be able to get rid of the duplicates if you replace the ALL('Table') with

CALCULATETABLE( SUMMARIZE( 'Table', 'Table'[idclient], 'Table'[idticket], 'Table'[Date_time]),
    REMOVEFILTERS( 'Table' )
)