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  thank you very much.

 

Can you add this in the powerbi file and share it with me. so it will be very helpfull for me.

 

Waiting for your reply

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

Hi,

 

I am sorry to have kept you waiting, here is my test pbix file:

pbix 

If my answer has solved your issue, please mark it as a solution for others to see.
Thanks!

 

Best Regards,

Giotto

  • 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: