will always return 1.
For every group of rows of a given ID the count distinct of that ID is 1. You may want to use the COUNT and not the COUNTD.
Thank you Michel, however, this does not work.
"For every group of rows of a given ID the count distinct of that ID is 1. "
So what I want to do is count the number of row that have this given ID.
How should I write this? Is this the way you suggest it?
will give you the number of rows per Id in all the data set independently of what you have on the filter shelf.
If you have some filtering, and some rows should be filtered out, then you could add your filters to Context.
You can check the following blog to see the order of operations that Tableau uses.