cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EZV12
Helper III
Helper III

Pbix report under DirectQuery mode - Questions & need help for solutions

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:

EZV12_0-1621169584959.pngEZV12_1-1621169602374.pngEZV12_2-1621169620583.pngEZV12_3-1621169633392.png

 

Many thanks in advance for your kind help!

Best regards

Rachel

@yingyinr 

1 ACCEPTED SOLUTION
selimovd
Community Champion
Community Champion

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:

selimovd_0-1621256635247.png

 

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 regards
Denis
 

View solution in original post

3 REPLIES 3
selimovd
Community Champion
Community Champion

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:

selimovd_0-1621256635247.png

 

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 regards
Denis
 

View solution in original post

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

selimovd
Community Champion
Community Champion

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 regards
Denis
 

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors