Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JeroenZuidlaren
Frequent Visitor

Summarizing results in table with non-active relation

Hello,

This is a follow-up of an earlier posts about the same dataset which I have problems with. @Greg_Deckler . 

 

Please find sample data here: https://drive.google.com/file/d/1fIJAtZA5BYq8PWSRpxfwblE0trIy6rm8/view?usp=drive_link 

Thanks to @v-yaningy-msft !

 

Simplified picture of the model see below and sample data.

Code > Business Units
Project > Project numbers and name
BudgetNEW > Budget for hours in 2024 including tariffs.
Data > hours registered by employees
Employee> Employee db. Indicating Employees Business units etc.

JeroenZuidlaren_0-1713438503235.png

 

I am creating an overview based on Table "Code" - field "Business Unit" for several measures. I am able to see hours registered etc. etc. [see below].

Now I want to look to the hours registered via the “AdminBU” in the budget table.
These hours I want to multiply bij an amount coming from some parameters - summarized by the measure “Sample_Result”.

As you can see I have now only values for BU3 and BU4 which is correct.

However I would like to project these values on the ‘regular’ Business Units (from table Code) I have built my table on. See also picture and sample data.

It would be great if I could also use these values in summations over the normal business units afterwards. So add it to the “Cost of hours” for example.

JeroenZuidlaren_1-1713438503240.png

 

Total for DAX measure does not work [SUMMARIZE function] 

 

 

 

 

1 REPLY 1
v-yaningy-msft
Community Support
Community Support

Hi, @JeroenZuidlaren 

You can use Google Drive to upload your pbix file (set it up to download without logging into your account).

Best Regards,
Yang
Community Support Team

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.