Forum Discussion

marcvd's avatar
marcvd
Frequent Visitor
5 years ago
Solved

Determining a specific value without getting an average value..

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

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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

2 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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


  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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