Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi  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!