SQL Server Reporting Services (SSRS) – Determine if all values are selected in a multi-value parameter

=iif(countrows(“dsCarMake”) = Parameters!CarMake.Count, “DO SOMETHING”, “DO SOMETHING ELSE”)

Explanation:

I have a parameter called CarMake. I load this parameter from a dataset called dsCarMake. The parameter is set to allow multiple values.

Let’s say a total of fifty Car Make’s …