count_where
Generate a complete SSRS conditional-count expression using =Sum(IIf(condition, 1, 0)) for Power BI paginated reports. Accepts an RDL expression body without leading equals sign.
Instructions
Emit =Sum(IIf(, 1, 0)) — the SSRS conditional-count idiom. condition is an RDL expression body (no leading '='). Returns a complete top-level expression suitable for set_textbox_value or any RDL sink.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"condition": "<condition>"
},
"name": "count_where"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| condition | Yes | RDL expression body, e.g. 'Fields!Status.Value = "Active"'. |