Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
MEASURE =
IF (SELECTEDVALUE('Calendar'[Week]) <>1,
@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())
@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())
MEASURE =
IF (SELECTEDVALUE('Calendar'[Week]) <>1,
Perfect. Thank you.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |