Forum Discussion
Dynamic subscription with multiple parameter value
Hi Phylicia,
Thank you Akash_Varuna for the solution you provided.I appreciate the detailed explanation of your scenario. The issue occurs because your dynamic subscription parameter table includes multiple rows for each user, which leads Power BI to send separate report emails for every row.
To address this, I suggest consolidating the countries for each user into a single row by concatenating the country values (for example, "US,CA"). This ensures each email address appears only once, and the @country parameter will return all relevant data in one report.
Here is an example of the aggregated table format:
Email | Country
[email protected] | US, CA
With this approach, you can use the new table for your dynamic subscription, and your existing CONTAINSSTRING(@country, Sales[Country]) logic will continue to function as intended.Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!
Regards,
Sahasra.
Hi Phylicia preprocess your semantic model to combine multiple countries for each user into one row (e.g., US, CA). Update the paginated report query to handle multiple countries by splitting the parameter dynamically and filtering the data (e.g., using IN logic).
EVALUATE
SUMMARIZECOLUMNS(
Sales[Sales amount],
Sales[Country],
FILTER(
Sales,
Sales[Country] IN {"US", "CA"}
)
)Pass the combined Country string (e.g., US, CA) as a single parameter.
VAR SelectedCountries = SPLIT(@country, ", ")
RETURN
FILTER(Sales, Sales[Country] IN SelectedCountries)