Forum Discussion
Helper IVSummarizing like data across multiple tables into a single report
Hi gemcityzach
Appending similar data into an "Append" query and creating measures based on this query would be more efficient. This can help you avoid creating many duplicated measures based on different tables. From your test, you already found that the DAX queries from the Append took less time than the dual query. 10,000 records in a query is not a problem. Power BI is able to deal with this data size quickly. By adding tblSrc column to a slicer or a filter, we can use the slicer/filter to switch viewing data of all tables or a specific table.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Helper IVThanks Jing. If I use this append table, then all of my measures will need to account for the multitude of table-column 'relationships'? I.e., if I want to get a count of total records, it'll have to be on all of the particular columns of each segment of the appended table? E.g., tbl1_specific_col + tbl2_specific_col + tbl3_specific_col and if I need filtering then I'll have to ensure that I apply any conditional logic specific to each filterable table-column resource that I want included. I.e., if I only need a measure for tbl1 and tbl2 data, then I have to make sure I'm specific to pick columns and filter variables that only affect the columns and rows from those particular fields?