I have a dashboard in tableau and also a filter where i can choose campaign type and also select ALL campaig types - when the ALL option is shown, the percentage is 183% which is wrong, I want to know the percentage of the filter across all the campaigns,

Using SUM(0) looks interesting, but you're going to have to explain a lot more about the problem so we can help.

Can you attach a packaged workbook please? do NOT post confidential data, but you have to include enough so we can understand what's wrong.

-----------------------------------------------------------

2022 Tableau Forums Ambassador

Based in Sydney, Australia (GMT+10)

Please upvote my helpful replies and choose Select as Best Answer if it really is the best :)