Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Multiple relationships between multiple tables

Hi,   I have an issue with relationships set in my dataset.   I have 4 related tables Calendar, Sales Data, Brands, Forecast, with the below relationships: 1.  Calendar => Forecast (Date=Date)...
Need Help
Tips and Tricks
v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi, Anonymous 

You can create relationships for these tables like the following.

 

 

The result looks like this:

 

Here is the pbix.

 

Best Regards

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Unfortunately this scenario is not possible for me as the dashboard is pretty big and a lot of data/calculated colums/measures will be impacted if the model will be changed. I'm thinking about a DAX calculation maybe?

     

    Anyway, thank you very much for your input.

    • v-cazheng-msft's avatar
      v-cazheng-msft
      Community Support
      5 years ago

      Hi, Anonymous 

      If so, you can consider doing calculation with TREATAS function which can create virtual relationship. And then use the result to create the visual.

       

      Best Regards

      Caiyun Zheng