Zhouyi, u are really the guru man... Ive spent more than a day together with my tableau team but we couldn't come to this solution...
Thank you so much for your help!!
Zhouyi Zhang Is it possible to sum up all the 1s in the [Count check] measure that you have created?
After I have removed all the other fields, the sum of [Count check] is 0.
I have tried LOD and running_sum but it didn't work.
Appreciate your help on this again! Thank you