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

Amazon QuickSight Community

Count Distinct Over If

Question & Answer

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

2 Likes