Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

PowerBI Report builder - DAX query Performance analyzer issue

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!

1 Reply