Forum Discussion

Bhargav150's avatar
Bhargav150
Frequent Visitor
2 years ago
Solved

Power bi report builder not taking parameters

I'm pulling the data source from power bi datasets in power bi report builder and trying to execute the below query but getting error

 

Query in dataset1

 

EVALUATE SUMMARIZECOLUMNS('Query1'[LOAN_NUMBER], 'Query1'[LOAN_ORIGINATOR_NAME], 'Query1'[LOAN_MODIFICATION_DATE], FILTER(VALUES('Query1'[LOAN_NUMBER]), 'Query1'[LOAN_NUMBER] IN (@LN)))

 

Error

Query (1, 154) The function expects a table expression for argument '1', but a string or numeric expression was used. 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI Bhargav150,

    Perhaps you can try to use following Dax formula if it suitable for your requirement:

     

    SUMMARIZE (
    FILTER ( ALLSELECTED ( 'Query1' ), 'Query1'[LOAN_NUMBER] IN ( @LN ) ),
    'Query1'[LOAN_NUMBER],
    'Query1'[LOAN_ORIGINATOR_NAME],
    'Query1'[LOAN_MODIFICATION_DATE]
)

     

    If you are trying to use multi-value parameters, you can also take a look at the official document:

    Add a multi-value parameter to a paginated report - Power BI | Microsoft Learn

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI Bhargav150,

    Perhaps you can try to use following Dax formula if it suitable for your requirement:

     

    SUMMARIZE (
    FILTER ( ALLSELECTED ( 'Query1' ), 'Query1'[LOAN_NUMBER] IN ( @LN ) ),
    'Query1'[LOAN_NUMBER],
    'Query1'[LOAN_ORIGINATOR_NAME],
    'Query1'[LOAN_MODIFICATION_DATE]
)

     

    If you are trying to use multi-value parameters, you can also take a look at the official document:

    Add a multi-value parameter to a paginated report - Power BI | Microsoft Learn

    Regards,

    Xiaoxin Sheng