Hello,

This seems a simple problem, but confused me a lot...

The original data is as right part, the formatted table in Tableau is as left part. I want to calculate Valid_Rate = amount(valid equal1) / amount(name) = 3 / 6 = 50%

It is easy to calculate name amount with COUNTD([name]), the question is: how to calculate valid amount? (the amount should be 3)

Very appropriate for any help.

formatted table	original data
	name valid other a 1 asdf b 0 df a 1 ghf a 1 werw a 1 sdf b 0 xcv c 0 tyu c 0 khjk d 1 iuo d 1 kjl e 0 nd e 0 werw f 1 xcx f 1 cfg

Thanks,

Rowe