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...
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

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