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