Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Everybody,
I have some problems in builing pbix report under DQ mode. As tables of data are hidden, I cannot creat fusions, neither add tables or columns...
Here is the link https://1drv.ms/u/s!AnbNXrfr-X8jdCh4I-viYzEgvpw?e=kGjuRO for a sample file pbix. I created it by entering the data manually, but the real report is under DQ mode. It would be great if you may help me to figure out some DAX formulas.
Here below please some images in which I explained my problems and asked questions:
Many thanks in advance for your kind help!
Best regards
Rachel
@Anonymous
Solved! Go to Solution.
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
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
64 | |
50 | |
36 | |
26 |
User | Count |
---|---|
86 | |
55 | |
44 | |
43 | |
36 |