Hi @mark goldin ,
The Lookup function is used to retrieve the value from the specified dataset for a name/value pair where there is a 1-to-1 relationship. Mostly used to refer to field values in the second dataset. A Tablix corresponds to a dataset, and the Lookup Function is used when you need to refer to other datasets.
If you need to filter in the same dataset, you can do it in the following way. Set the fill property of the cell.
As shown below:
Use the IIF expression to set the fill background color. The following expression is set as: when the parameter value is "A" and the Type value is "Y", the cell background color is Red, otherwise it is white.
Preview:
Similarly, you can use the following expressions to filter the dataset:
IIF(Fields!ID.Value="26" AND Fields!Score.Value = -1,"Red","White")
If I misunderstand what you mean, please feel free to let me know.
Best Regards,
Joy
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.