Forum Discussion
zenisekd
Super User
1 year agoPerformance question
Hi, I have a fact table, which has a couple millions of rows. Among other columns, there is "Product Code", which only contains product code and does not have any relationship to another table. ...
- 1 year ago
Hi zenisekd, unless you are using DirectQuery, having a separate table won’t improve slicer speed.
The performance of a slicer is mainly affected by the cardinality (the number of unique values) in the column, not the total number of rows in the fact table.
If there were additional attributes related to the "Product Code" (e.g., product name, category, price, etc.), then a dimension table would be beneficial for data modeling and easier filtering.
zenisekd
Super User
1 year agoI dont think so. Can you explain why? Even chat gpt agrees with me, saying "creating a separate dimension table for "Product Code" in this scenario is unlikely to provide any significant performance improvement in Power BI".
powerbiexpert22
Impactful Individual
1 year ago- zenisekd1 year ago
Super User
So in this scenario, you agree with me 🙂
- powerbiexpert221 year ago
Impactful Individual
Hi zenisekd
yes