Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Multiple values for in a Paginated Report using DAX.

I'm new creating Paginated Reports.

I have created a very basic one where I migrated one visual in PBX. I've got the DAX Query from the performance analyzer, replacing the hard-coded value with my data set parameter : @FiscalYear. This parameter mapped to the Report Parameter @Year (INT Type). This is the query (after deleting unnecessary lines):

// DAX Query
DEFINE
    VAR __DS0FilterTable = 
        TREATAS({@FiscalYear}, 'Calendar'[Year])

    VAR __DS0Core = 
        SUMMARIZECOLUMNS(
            'Calendar'[Year],
            'Stores'[store_country],
            'Stores'[store_city],
            'Stores'[store_name],
            __DS0FilterTable,
            "Total_Transactions", 'Transaction_Data'[Total Transactions],
            "Weekend_Transactions", 'Transaction_Data'[Weekend Transactions],
            "Total_Cost", 'Transaction_Data'[Total Cost]
        )
        

EVALUATE
    __DS0Core

 

In Power BI's report the paginated report was working fine for one single value: 

Now it is necessary to allow multiple values for the year.  I updated the parameter definition for allowing multiples values, but when I execute the report again I've got this message : 

Cannot convert value '{ 1997,1998 }' of type Text to type Integer while processing column - [StaticColumn] -> Calendar[Year].

 

I tried to change the data type to String, and join the values in the FX but without any success.. I have checked other alternatives within the function, always getting the same result.

 

What do I need to change in the DAX definition or the parameter attributes to reach the expected result ?

 

1 Reply

  • Anonymous , Have selected multiple values in the parameter, you created