PowerBI Report builder - DAX query Performance analyzer issue

Anonymous — Mon, 29 Nov 2021 09:20:10 GMT

Hi All,

I have created a report using PowerBI Report builder and the dataset query is coming from Performance Analyzer.

I define a Year and Month parameter but if I choose a multiple value on year or month i'm getting an error or no data displayed on the report. If i choose single value on the parameter the report is working.

Another thing, if i choose multiple value on year parameter, i'm also getting an error.

cannot covert value <pii>2019|2020</pii> of type tp type integer while processing column <pii>[static column]->datetable[Received Year]</pii>

Parameter: set expression value

=Join(Parameters!Year.Value,"|")

=Join(Parameters!Month.Value,"|")

Below is the DAX query.

// DAX Query
DEFINE

VAR __DS0FilterTable =
TREATAS({@Year}, 'DateTable'[Received Year])

VAR __DS0FilterTable1 =
TREATAS({@Month}, 'DateTable'[MonthName])

VAR __DS0FilterTable2 =
TREATAS({"Phone"}, 'CSST'[Product Group])

VAR __DS0FilterTable3 =
TREATAS({"AER"}, 'CCST'[Category])

EVALUATE
TOPN(
501,
SUMMARIZECOLUMNS(
ROLLUPADDISSUBTOTAL(
'CSST'[Category], "IsGrandTotalRowTotal",
'CSST'[Client], "IsDM0Total",

I believe the parameters are just not working correctly or the DAX query, likely, something wrong I did, but I have no idea how to fix this. I have tried innumerous things! Please help!

Thank you!

Re: PowerBI Report builder - DAX query Performance analyzer issue

Anonymous — Thu, 02 Dec 2021 01:18:28 GMT

Hi @Anonymous,

I'd like to suggest you check the configuration to confirm you have enabled the 'Allow multiple values' property :

Report parameters in Power BI Report Builder - Power BI | Microsoft Docs

If you are working with parameter filter in URL, please check the following link to ensure you are using the correct format of multi-value parameter:

Pass a report parameter in a URL for a paginated report - Power BI Report Builder - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

topic PowerBI Report builder - DAX query Performance analyzer issue in Developer

PowerBI Report builder - DAX query Performance analyzer issue

Re: PowerBI Report builder - DAX query Performance analyzer issue