Forum Discussion

helalm's avatar
helalm
Icon for Helper II rankHelper II
5 years ago

Entire Table Columns Extraction with Slicer Selection

I have multiple tables that are joined by key column (SubjectID) in an Star schema. The Main Table is left joined with the rest. Each table has a common column (Form No) that contains unique identifi...
Need Help
helalm's avatar
helalm
Icon for Helper II rankHelper II
5 years ago

Hi Rena,

That's a very cleaver approach. The only drawback is I have close to 100 tables and each table has an average of 50 columns. Merging all table into one flat file will constitue 5000 columns. I don't think that would be very effiecinet method. I should have been clear when I posted the issue. Someone suggested that I shouod look into HASONEFILTER and All, and SELECTALL in DAX. What do you think?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi helalm ,

    Sorry that I didn’t find the other suitable way to achieve your needs. Maybe you can take a look at the following thread, hope it can help you.

    Common Slicers for Multiple Tables

    Best Regards