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

 

Anonymous's avatar
Anonymous
Not applicable
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)))