Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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
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
User | Count |
---|---|
14 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
15 | |
4 | |
3 | |
3 | |
2 |