Determining a specific value without getting an average value..

[marcvd]

Hi all!

Hope I phrased my question well.

So I am struggling with determining the specific salary cost for a client.

1. Employees register their working hours per (project per) client.
2. The salary cost is booked per employee.

Now I want to compare the hours of each individual employee with the salary cost of this employee.

Attached a sample pbix file with more details.

Thanks in advance!!

M

https://1drv.ms/u/s!Akj7bUrQd6tMxFDw23Z_exc-vMG7?e=u1sybe

[v-easonf-msft · Accepted solution]

Hi, @marcvd 

Try to add  a new measure as below:

Result2 = SUMX(VALUES('DATE'[MONTH]),[RESULT])

BTY,It is not recommended to send me private messages. If you have any questions, it is recommended to post directly on the forum.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi， @marcvd 

Sorry, can you explain your needs and expected results in detail?

I did not see any abnormalities in your pbix.

Isn't the result of  measure [SOLUTION!] what you want?

Best Regards,
Community Support Team _ Eason