Forum Discussion
Using a text filter and getting around Direct Query row limit
Hi, have you considered using incremental refresh on your model? This will enable you to keep your pbix file relatively empty whilst building history on your deployed model in the service.
Hi ali_iopp,
Thank you for reaching out to Microsoft Fabric Community.
Please follow below steps:
- Create a small table using Enter Data for user entered Asset IDs and add the AssetId data manually, do not create a relationship between this table and your main fact table.
- Now create a DAX measure in the main fact table like this below:
Filter_AssetID =
IF (
SELECTEDVALUE(FactTableName[AssetID]) IN VALUES(AssetID_Input[AssetID]),
1,
0
)
This measure checks whether the current row's Asset ID exists in the input list.
- Go to the visual and in the Filters pane, drag the Filter_AssetID measure into the visual level filter section and set it to:
Filter_AssetID is 1
This will show only the records matching the entered Asset IDs
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
I think this wouldn't work for my use case, the issue is that report users want to search for an AssetID themselves and this solution I think does not work dynamically?