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

Hi Anonymous ,

 

1. Create a conditional column.

2. Create New column.

FTE = 'sample data'[Hours]/'sample data'[Time calc]
 
Output:

 

Best Regards,

Shreya Mukkawar

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and Like the solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

     

    when you divide 3753 on 48 it should give 77.81

    thanks