Dimension Table

[PowerBI123456]

Hi - Need some tips/advice on the model I am working on. Its pretty complex with a lot tables and some of my fact tables have 20 million +rows.  When creating my visualizations, is it better (performance wise) to filter on fields in my Fact tables or is better to create dimension tables (would only be one column) and filter off that? For example, I have to filter on one field "FieldName" in one of my fact tables that has about 100 different options. Would it better to create a dimension table with those 100 different options, link it to my fact table, and filter off the dimension table instead? 

[v-lionel-msft]

Hi @PowerBI123456 ,

Continue to create dimension tables will make the data set larger, which in turn will slow down refreshes and queries.
Try to refer to the link.

Data reduction techniques for Import modeling 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pc2]

Yes, it should improve the performance... try it and see.

I would create a dynamic table based off your fact table, create a New Table, = distinct(FactTable[columnName]).  Then create the relationship with the FactTable.

Also, use the "Performance Analyzer" under View menu to test the performance.