Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
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 |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |