Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count Rows Function works only for one category

Hi all, I have an appended query where all the models of 5 products are listed in the [Model] column with other columns like [Update Date]. I have created a count function that counts the same Models...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I solved the issue: in the table with the category, model, Update Date, and Count, I had the serial number column. By remove it, the count works. I think that the serial number column was filtering in the measure in some way. Thanks for your support.

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , what is the expected output?

 

If this is a column try like

 


Count = CALCULATE( COUNT('Group'[Model]), filter('Group','Group'[Update Date] = earlier([Update Date] ) && 'Group'[Model] = earlier('Group'[Model])))

 

if measure , try like

Count = CALCULATE( COUNT('Group'[Model]), filter(allselected('Group'),'Group'[Update Date] = max([Update Date] ) && 'Group'[Model] = max('Group'[Model])))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for your help. I have tried the measure you posted and the result is the same: it works for the bycicle category and not for the e-bikes category. 

 

The expected output is like the table in the first post with the correct e-bikes count per same model and same Update date. The table shows that there are 2 e-bikes with Go-go model and 12/12/2021 update date, the count is right but they are not grouped in one row.

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , if the date does not have timestamp, in table visual both rows should merge. Even for simple count like below example