Hello, I am building a dynamic Quick Sight Visual where users can toggle between different views. Here’s the setup: ${ShelfChangesValueParam} is a parameter that lets users choose between: Placements Average $ Net Price Average $ Promotion Average % Discount ${ShelfChangesParam} is a param…

Hello @Nikhilburhade , maybe we can try simplifying the dynamic price band field and break it out into multiple calculations to see if we can resolve the issue. We could also try adding a version of it on the dataset and then apply some filtering on the visual to fix the problem similarly to the topi…

Urgent DistinctCountOver() Function Issue

Q&A

Nikhilburhade May 29, 2025, 11:41am 15

Hello @DylanM

Do we have any further update on this issue ?
Also, I came across a related issue that seems quite similar:
(Distinctcountover not taking calculative field as partition by field - #6 by Jesse)

Regards,
Nikhil.

Topic		Replies	Views
Please Contact the Quicksight Team to solve this issue Q&A analysis , quick-sight , calculations	3	996	October 14, 2022
Filter not applied to the distinct count of records Q&A quick-sight , calculations , how-to	11	1423	January 31, 2023
Distinctcountover partition by field syntax error Q&A analysis , parameters , quick-sight , calculations , Business-Intelligence-Engineer	7	467	October 30, 2023
Distinctcountover error - Your calculated field expression contains invalid syntax Q&A analysis , quick-sight , calculations	3	2075	October 27, 2022
Is there any other way to display the totals as the show total option is not displaying any value for the custom field Q&A quick-sight	3	464	November 18, 2022

** Urgent ** DistinctCountOver() Function Issue

Related topics

Urgent DistinctCountOver() Function Issue