Help building measure in DAX

fblourido — Wed, 17 Nov 2021 23:00:34 GMT

Hi all!

I'm sorry if this is a post repetition but I couldn't find an answer and I'm going around in circles for days trying to understand why this doesn't work. My head hearts! 😄

I've the following model and I´m trying to find the "Total cost HR" in the "Custo HR" table, being able to filter by "Contratos" and "Recursos" and I'm not being able to as it shows on the below table. I was expecting that "Total cost HR" was affect by the "Hours" in the "Timesheet" table but I see now that there is no direct way to relate "Hours" to "Total cost HR".

Well I'm guessing now that perhaps the way to go is to build a measure using DAX but my skills are still very limited. I'm able to create a measure that gives me the "Cost per Hour" on a given temporal slice, but that cost is not affected by the other selections on "Contratos" and hence by "Hours" on "Timesheet" table. With that I guess I could eventually create a measure for the cost on a given "Contratos" if I could multiply the measure "Cost per Hour" by the hours on a given "Contratos" filtered "Timesheet" but I'm not being able to get those "hours" on "Timesheet" table. They appear on the table but I don't no how to get them.

Can you please help? Thanks in advance for your time!

Re: Help building measure in DAX

Stachu — Thu, 18 Nov 2021 08:31:25 GMT

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5

topic Re: Help building measure in DAX in DAX Commands and Tips

Help building measure in DAX

Re: Help building measure in DAX