Unfortunately, you cannot use a discrete aggregate calculation (e.g. COUNT in an IIF that results in string) as a filter. You can use a continuous aggregate. So, in your calc above, if you change 'Vide' to 0 and 'Complet' to 1 you should be able to change the field to continuous and then use it on the Filters shelf.
Happy New Year!
Happy New Year Joshua and Thank you for your reposne;
I change 'Vide' to 0 and 'Complet' to 1 and Ichange the field to continuous and then use it on the Filters shelf.
But; Can I after that , display the 0 as 'Vide' and 1 as 'Complet'??
Thank you again
1 of 1 people found this helpful
Not directly. However you could use a parameter. If you create a parameter like this (note the All option is optional and only if you want to give the option for showing Vide and Complet at the same time):
Then you can change your calculated field (or create a new one) that uses the parameter values. It would be something like this:
[VIDE_Complet Parameter] == -1
([VIDE_Complet Parameter] == 0 AND COUNT(Student) == 0)
([VIDE_Complet Parameter] == 1 AND COUNT(Student) != 0)
As a continuous aggregate, you should be able to place that filter calculation on the Filters shelf and keep where it is at least 1.