Forum Discussion
Are there DAX implications for using primary keys in dimension tables?
I have a PBI data model, which is a star schema, but am wondering if there are any DAX implications for the design (I know certain data model designs can cause undesired results when writing DAX meas...
It's import. What do you mean what when you say: 'a view with distinct' please? Thanks.
PS I know how to create the tables in Power Bi. I'm asking if the dimension not including it's own Primary key is an issue.
v-kelly-msft
Community Support
Community SupportHi Anonymous ,
It is a good practice if the dimension includes it's own Primary key because it helps ensure that all your facts reference existing dimension members, and may improve performance but it is not mandatory.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!