Forum Discussion
Creating a relationship in Powerbi
I think i framed my question incorrectly. What i wanted to ask primarily was the way relationship to be made and not more focus on the dax measure. what are the best practices to create the relationship to get those dax measures correctly.
Hi, PradipMCT
Thank you very much for your reply and am very sorry for my late reply. On your first question, do you need dimension tables:
The golden rule of design is to make dimension tables wide enough, which can make dimension tables have powerful filtering capabilities. The more fields in a dimension table, the greater the ability to slice and dice the data.
In your scenario, if you need to filter data from different regions or some other operations, then having dimension tables is a great option.
The relationship you create should be based on your actual situation. Once the relationship is established, you can filter the data by fields between different tables. You can leave the links below, which have a detailed description and comparison of each relationship:
Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified - RADACAD
Also, it is recommended that you read these articles of this blog as shown in the image below. This will be helpful for you to understand relationships, dimension tables, and fact tables:
Build Your First Star Schema Model in Action: Power BI Modeling Basics - RADACAD
Regarding your second question, best practices for calculating metrics, you can refer to the following article. In these articles, there are various KPIs that you should use to choose the right solution for you.
In these samples, you can download them that are similar to your scenario. Open them in Power BI and learn about the different practices of metrics.
First, the official sample provided by Power BI:
Get samples for Power BI - Power BI | Microsoft Learn
Here are some of the practices you might be referring to:
Top 9 Power BI Dashboard Examples (zebrabi.com)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.