Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Measure

how to make the below highlight in on Measure ex , Us = sum( [houus] )/ 48. UK = sum( [houus] )/ 45. TN= sum( [houus] )/ 40 i want to make all of them in Measure   
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thanks All,
    i could not have solved without you , my solution is

    FTE =
     IF(SELECTEDVALUE(Overall[Location (Country)]) = "KSA", [hours] /48,

     IF(SELECTEDVALUE(Overall[Location (Country)]) = "UAE",
            [hours] /45,
     IF(SELECTEDVALUE(Overall[Location (Country)])= "Greece","Germany",
     [hours]/40)))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Can you explain more about this problem?

It will help to solve this problem.

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

ex ,
Us = sum( [houus] )/ 48.
UK = sum( [houus] )/ 45.
TN= sum( [houus] )/ 40
i want to make all of them in Measure