IF SELCECTEDVALUE with filters

[Qotsa]

Hi,

Below measure works but I need to apply a filter to both IF statements.

I want below measure to work but not if SELECTEDVALUE('Calendar'[Week]) = 1

Measure =

IF(SELECTEDVALUE('powerbi114 cmLevelBranch'[id]) = 83 ,15.6 + (.045 * SELECTEDVALUE('Calendar'[Week])),

IF(SELECTEDVALUE('powerbi114 cmLevelBranch'[id]) = 84 ,19.79 + (2 * SELECTEDVALUE('Calendar'[Week]))

[shzaidi · Accepted solution]

MEASURE =

IF (SELECTEDVALUE('Calendar'[Week]) <>1, 

IF(SELECTEDVALUE('powerbi114 cmLevelBranch'[id]) = 83 ,15.6 + (.045 * SELECTEDVALUE('Calendar'[Week])),

IF(SELECTEDVALUE('powerbi114 cmLevelBranch'[id]) = 84 ,19.79 + (2 * SELECTEDVALUE('Calendar'[Week]))

,0)

[amitchandak · Accepted solution]

@Qotsa , try  like

if(SELECTEDVALUE('Calendar'[Week])=<> 1,

IF(SELECTEDVALUE('powerbi114 cmLevelBranch'[id]) = 83 ,15.6 + (.045 * SELECTEDVALUE('Calendar'[Week])),

IF(SELECTEDVALUE('powerbi114 cmLevelBranch'[id]) = 84 ,19.79 + (2 * SELECTEDVALUE('Calendar'[Week])))),
blank())

[shzaidi · Accepted solution]

MEASURE =

IF (SELECTEDVALUE('Calendar'[Week]) <>1, 

IF(SELECTEDVALUE('powerbi114 cmLevelBranch'[id]) = 83 ,15.6 + (.045 * SELECTEDVALUE('Calendar'[Week])),

IF(SELECTEDVALUE('powerbi114 cmLevelBranch'[id]) = 84 ,19.79 + (2 * SELECTEDVALUE('Calendar'[Week]))

,0)

[Qotsa]

Perfect. Thank you.