Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
6 years ago

HC calculation

Hi amitchandak    Country Qtr Emp HC India Qtr 1 2019 Sam 234 India Qtr 1 2019 Raj 234 India Qtr 1 2019 kit 234 India Qtr 1 2019 mas 234 India Qtr 1 2019 den 234...
Need Help
unnijoy's avatar
unnijoy
Post Prodigy
6 years ago

v-gizhi-msft  I am not able to use this to calculate the %.

 

We are caculating the award % using the below Formula.

 

Awardf %= total award/ HC for that quarter,

 

But when i use the current formula i am getting wrong figure.

Please help.

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

For your requirement, i add some new data to original table:

Then try this measure:

Total Award/HC = SUM('Table'[Award])/MAX('Table'[HC])

It works well here:

If you want to contract the HC value, just try this:

_HC = CALCULATE(MAX('Table'[HC]),FILTER('Table',[Measure]=1))

Hope this helps.

 

Best Regards,

Giotto

  • unnijoy's avatar
    unnijoy
    Post Prodigy
    6 years ago

    Hi v-gizhi-msft ,

     

    thanks for the reply.

     

    Total award is counted by the count of employees.

     so in the below table if we gave employee id it will make our calculation easy.

     

    So total award = count of employee id

    I tried the formula that you gave. the issue is that the vale is not changing. it is always showing the latest month HC

    can you please show it in a powerbi file and share it with me

     

    Can you use the formul in graph as below

    X axis = Country name

    Value = count of employee ID/ HC

    Note: HC = HC of the selected quarter. IF all quarter is selectd then it should take Latest month HC.

     

    Please share the powerbi file also.

    I am using link and stacked column chart in powerbi.

     

    Thanks and sorry for asking all this modification. Today is my project deadline data. Thank you: