Counting values

[Anonymous]

Hi everyone, I have the following slicer and table:

Given that my user could alter this table with the slicer, I'm trying to write a measure to calculate the number of rows contained in the table visual, for the example above, I'd be looking for 21.

Can anyone help?

[amitchandak]

@Anonymous , countrows(Table)

or

count(Table[Day])

if days from different table

calculate(count(Day[Day]), not(isblank(Table[login time])))

[Anonymous]

Hi @amitchandak 

As you can see, I got a result of 731 instead of 21

The DAX i entered was this:

I can't fathom why I can't just simply count the rows of the visuals.

[Anonymous · Accepted solution]

Found the solution, COUNT should be DISTINCTCOUNT as there are multiple values for some days.

Thanks all