Forum Discussion
Column filters vs Table filter
Hello,
a bit of a theoretical question here, apologies if it's a bit basic but I'm relatively new to this.. so he goes and I'm grateful for any assistance . I would essentially like to know what the difference is between a column filter and a table filter. Why I'm scratching my head over this.. is because if I filter on a column , it will return a subset of a table with rows where the column I have filtered on equates to true. So the table is in effect filtered. What is the difference between this for example, and using the table function "filter" that will iterate over a table , and return a subset of that table , because in both instances the output is table with filtered rows .... sorry for the newbie question!
2 Replies
With DAX, you can get the same results with multiple approaches. However, how you construct the DAX can affect how the calculation is performed under the cover. Filtering a whole table usually results is worse performance (extra table scans, larger materialized tables, etc.). The SQLBI.com site is a great resource to learn much more.
Pat
Thanks very much for this . So in terms of the output , they both return a table of filtered results? Is that correct?
