ForEach Help (Losing aggregation)

[former_member636231]

Hi,

How can I keep my value when I delete 'Day', As you can see below each row is returning 1 instead of 4,4,5,6.

[saurabh_sonawane]

Hi

Please try this

complaince = If([target]>[actual];0;1)

=Count([complaince] In ([week];[Day]) Where ([complaince]=1))

Thanks,

[ayman_salem]

Just hide the day column (do not delete)

[amitrathi239]

What is the calculation of Compliance column?

try with changing the variable qualification to dimension and then use foreach() in the final avriable including of date object