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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.