why create new table from another table?

[WillBeeSEA]

I have seen various articles and videos on how to create a new table that filters out the data from another table to give you a specific subset of the original table.  I get the 'how' but I have not seen/heard any reason as to WHY.  It seems that creating a new table of stored data unnecessarily increases the size of the data model and that could negatively affect performance.  Why would I not just use one of the various methods of filtering data; slicers, the Filter pane, filter expressions in DAX, etc.?  I think I mainly need a few examples/situations/use cases where this would be better or necessary.

Thank you.

[WillBeeSEA]

@lbendlin ; thank you.  That makes sense. 

[v-csrikanth]

Hi @WillBeeSEA 
As highlighted by @lbendlin , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

Best Regards,
Cheri Srikanth

[lbendlin · Accepted solution]

One of the main goals in DAX Query optimization is the cardinality reduction.  You  balance the cost of additional storage with the benefits of smaller, more efficient queries.