Forum Discussion
Pbix report under DirectQuery mode - Questions & need help for solutions
Hey EZV12 ,
why do you want to combine the companies and the plants? I think you can do all the analysis when they are in different dimensional tables.
Then you don't do a relationship between the two fact tables KPI data and KPI Target, you connect them with the dimensional tables, like that:
Relationships are one of the basics of Power BI / DAX. You should take a time block and really try to understand them. I would recommend to start with the following articles:
Model relationships in Power BI Desktop - Power BI | Microsoft Docs
Relationships in Power BI and Tabular models - SQLBI
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
Hey EZV12 ,
why do you want to combine the companies and the plants? I think you can do all the analysis when they are in different dimensional tables.
Then you don't do a relationship between the two fact tables KPI data and KPI Target, you connect them with the dimensional tables, like that:
Relationships are one of the basics of Power BI / DAX. You should take a time block and really try to understand them. I would recommend to start with the following articles:
Model relationships in Power BI Desktop - Power BI | Microsoft Docs
Relationships in Power BI and Tabular models - SQLBI
Dear Denis,
Thank you very much for your reply. For my requests for DAX formulas, I published another message to better explain my needs. Here is the link: https://community.powerbi.com/t5/Desktop/DAX-formulas-requests-please-help/m-p/1846118
May you please help?
Many thanks.
Rachel
Hey EZV12 ,
I answered in the other post.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic