Hi Everyone, I have a need to do a count distinct over if. Unfortunately there’s no function for this, QS issues an error when I try to combine functions. The formula looks like this, but I need to replace avgOver with distinct count. Anyone have any ideas? avgOver( ifelse(${CurPlan}={Name (Plan)…

Hi @keith.fortier You can do distinct count over. This is your go to resource for this question. [image] Level-Aware Calculations: Tips and Best Practices Articles Great article @David_Wong ! Regards, Giri

Hi @keith.fortier It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you. If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic. Thank you!

Hi @keith.fortier Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information. Thank you!

Count Distinct Over If

Q&A

Giridhar.Prabhu December 18, 2024, 2:23pm 2

Hi @keith.fortier

You can do distinct count over. This is your go to resource for this question.

Regards,
Giri

Topic		Replies	Views
distinctCountOver if condition Q&A quick-sight , calculations	2	2462	March 31, 2023
distinctCountOver() throwing SQL exceptions with any ifelse() in First Argument Q&A error , quick-sight , Business-Intelligence-Engineer	7	102	September 10, 2025
distinctCountOver not working with Calculated Field (DISTINCTCOUNTOVER_INVALID_ARGUMENT) Q&A formulas , error , quick-sight , Business-Intelligence-Engineer	9	196	September 6, 2025
Distinct Count Over Q&A error , quick-sight , calculations , Business-Intelligence-Engineer	2	404	October 22, 2023
distinct_count/distinctCountOver alternative Q&A data-source , error , quick-sight , calculations , Business-Intelligence-Engineer	3	90	December 27, 2024

Count Distinct Over If

Related topics