Count on if condition

[Anonymous]

Please refer the table below:

I want an expression to count number if all the values design_accept=3.

Eg; If all the values for design_accept=3 for each MachDateKey then it should count as 1.

Please assist.

[Anonymous]

Assume I have two data sets 'X' and 'Y' of two different weeks.

X being the current week and Y being the previous week which had Date field storing two different dates.

I have declared two variables vMaxDate=Max(Date) and vMinDate=Min(Date).

I want to use these variables in the above set analysis expression for counting the same field.

What modifications should I do to the above set analysis expressions given as correct for this post ?

[Anonymous]

For this expression : Count({<MachDateKey = {"=design_accept = 3"}>} DISTINCT MachDateKey)

[sunny_talwar]

Assume I have ...

Sample works much better then Assuming

[Anonymous]

This expression is working weird for me.

It's giving the correct output at one point and then again when I reload new data, it's giving wrong output.

I am unable to follow the syntax of this set analysis expression.

Please assist.

[sunny_talwar]

Can you provide a sample to show where this isn't working?