How to distinct count ID

[Anonymous]

I have a count if statement in my straight table that I am using to distinct count IDs. it is counting the no of records instead even when I use distinct. any idea?

[sunny_talwar]

Without seeing a sample, it would be hard to say what might be wrong.

[MK_QSL]

Count(Distinct ID) should give your expected result. If not, please share some sample/dummy data or sample application.

Or provide the Data Model, Dimension or Expression you have used..

[Anonymous]

The count was not matching because I had a calculated dimension but in the expression, that dimension was not being used. hence when I copied the expression to the caption of the straight table, it was giving me a diff count than the number of record in the straight table.