Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Without seeing a sample, it would be hard to say what might be wrong.
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..
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.