Do you create an M query parameter for the Number ID? If I understand it correctly, the Dynamic M query parameters in Power BI Desktop feature should be helpful. With dynamic M query parameters, model authors can configure the filter or slicer values that report viewers can use for an M query parameter. Dynamic M query parameters give model authors more control over the filter selections to incorporate into DirectQuery source queries.
This feature is not supported if you get data from data sources with Import mode.
In addition, your other tables should have relationships to the first table based on the Number ID column, so that they can be filtered by the first table.
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.