Forum Discussion

RemiAnthonise's avatar
RemiAnthonise
Icon for Helper V rankHelper V
8 years ago
Solved

Multiple values in SELECTEDVALUE

Hi guys,  I have this formula: Workinghours per month=  IF ( SELECTEDVALUE ('Workers'[Name]) = "Test Employee"; CALCULATE ( SUMX ('Calendar'; 'Calendar'[Workdays 4 days] ) ) * [Workinghours9];...
Need Help
Show and Tell
Tips and Tricks
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi RemiAnthonise,

 

Here we can use IF and OR instead of ||

 

Workinghours per month both =
IF (
OR(
SELECTEDVALUE('Workers'[Name])= "Test Employee";
SELECTEDVALUE('Workers'[Name])= "Test Person");
CALCULATE(SUMX('Calendar';'Calendar'[Workdays 4 days]))* [Workinghours9],
CALCULATE(SUMX('Calendar';'Calendar'[Workdays 5 days]))* [Workinghours8])

There is an example in the attached pbix.

https://www.dropbox.com/s/eudlobbyoz279bz/Multiple%20values%20in%20SELECTEDVALUE.pbix?dl=0


Regards,
Frank

kohlivinayak's avatar
kohlivinayak
Icon for Resolver I rankResolver I
8 years ago

Hi RemiAnthonise

 

Create a new measure for selected value

 

Selected = SELECTEDVALUE
('Workers'[Name])

 

IF ( Selected = "Test Employee" || Selected = "Test Person";
CALCULATE ( SUMX ('Calendar'; 'Calendar'[Workdays 4 days] ) ) * [Workinghours9];
CALCULATE ( SUMX ('Calendar'; 'Calendar'[Workdays 5 days] ) ) * [Workinghours8]
)

 

the thing is you have to repeat the expression it has to compare.

 

A better approach is what v-frfei-msft has already told you.

  • RemiAnthonise's avatar
    RemiAnthonise
    Icon for Helper V rankHelper V
    8 years ago

    kohlivinayak yes you're right, I've tried the way as v-frfei-msft told me and this did the trick.

    Thanks for your time, guys.