Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 @Anonymous !
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.
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.
Total for DAX measure does not work [SUMMARIZE function]
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
User | Count |
---|---|
82 | |
72 | |
67 | |
47 | |
36 |
User | Count |
---|---|
111 | |
56 | |
50 | |
42 | |
40 |