Hello,   I tried to duplicate your issue and I got REALLY confused... until I realized that I was seeing aggregated values! 🙂   In the options for your list table, enable "Detail data" and your numbers should make sense again. (ETA: +1 to what @TSBruce said) Let us know if that helps, Sam ... View more

Oh, I see. The problem is the nested operations when you have an aggregated measure (Distinct Count) in the expression. I think the best workaround is to pre-calculate the distinct count as part of your data preparation.   If you have the very latest version of VA (2024.05), you can work around this by calculating the distinct count as part of an expression-based parameter. ... View more

Hello,   Probably the issue is that your ID column has duplicate values. If you have permissions to perform data preparation tasks, then you could try generating a new ID column: https://go.documentation.sas.com/doc/en/dprepcdc/v_023/datastudioadv/n0ooiqdt13mn6sn1ejbeyv4ech8d.htm   It might also possible to create a calculated item with unique values within VA by concatenating your ID column with another one such as a date column. That would depend on your data.   You might want to create a list table of your data (including the ID column) and sort by frequency. That might help you find what the duplicates look like and determine how best to address them.   Let us know if that helps, Sam ... View more

As noted above, VA does not remove duplicates but it aggregates them.   If you want to see multiple instances of the same categorical values in a table in VA, enable "Detail data" on the Options pane. ... View more