Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm working on building a staffing calculator. Essentially the dashboard user is able to update inputs on the fly using PowerBI parameters which then feed into into a bullet chart that shows current headcount vs. what the calculator says we need (see below). However, the tricky part is that some roles need to be calculated based off the results returned for the subordinate roles. I've posted a screenshot below as an example. I'm having trouble creating a measure that combines the results for the associate roles and also calculates the manager headcount based off the projected heacount of the corresponding associate role.
Let me know if you need any more details and I appreciate the help!
*Graph is just example of desired outcome, not currently working in Power BI
Solved! Go to Solution.
Hi @Index_Match ,
Please use switch function to create measure like below:
Measure = SWITCH(TRUE(),
MAX('Table'[Column1])="aa",Parameter[Parameter Value],
MAX('Table'[Column1])="am",Parameter[Parameter Value]/10,
MAX('Table'[Column1])="fa",'Parameter 2'[Parameter Value 2],
MAX('Table'[Column1])="fm",'Parameter 2'[Parameter Value 2]/5)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Index_Match ,
Please use switch function to create measure like below:
Measure = SWITCH(TRUE(),
MAX('Table'[Column1])="aa",Parameter[Parameter Value],
MAX('Table'[Column1])="am",Parameter[Parameter Value]/10,
MAX('Table'[Column1])="fa",'Parameter 2'[Parameter Value 2],
MAX('Table'[Column1])="fm",'Parameter 2'[Parameter Value 2]/5)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This was one component of the overall solution. I also had to use the VAR function to find the total headcount for just "aa" and then use that measure in place of the parameters you have shown.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |