Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TarifAlanazi
Helper II
Helper II

Measure

how to make the below highlight in on Measure

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

 

1 ACCEPTED SOLUTION

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)))

View solution in original post

7 REPLIES 7
v-mengzhu-msft
Community Support
Community Support

Hi @TarifAlanazi ,

 

Like this?

vmengzhumsft_0-1669101101530.png

just create a measure:

FTE = var _US=SELECTEDVALUE('Table'[hours])/48
Var _UK=SELECTEDVALUE('Table'[hours])/45
var _UETN=SELECTEDVALUE('Table'[hours])/40
return IF(SELECTEDVALUE('Table'[item])="US",_US,IF(SELECTEDVALUE('Table'[item])="UK",_UK,_UETN))

And you can also refer to my pbix file for better understanding.

 

Best regards,

Community Support Team Selina zhu

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

TarifAlanazi_0-1669105345130.png

 

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)))
shreyamukkawar
Resolver II
Resolver II

Hi @TarifAlanazi ,

 

1. Create a conditional column.

shreyamukkawar_0-1669036294966.png

2. Create New column.

FTE = 'sample data'[Hours]/'sample data'[Time calc]
 
Output:
shreyamukkawar_1-1669036383171.png

 

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.

TarifAlanazi_2-1669097578624.png

 

when you divide 3753 on 48 it should give 77.81

thanks

 

shreyamukkawar
Resolver II
Resolver II

Can you explain more about this problem?

It will help to solve this problem.

 

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

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors