Forum Discussion
IF SELCECTEDVALUE with filters
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]))
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)Anonymous , 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())
3 Replies
shzaidiHelper I
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
Super User
Anonymous , 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())