Forum Discussion

ellynneu's avatar
ellynneu
New Member
2 years ago
Solved

DAX Measure with Parameter

Hello, I am struggling to write the correct DAX measure, most likely due to the measures referencing a paramater. Here is my current data: I have Shift (static within table 'Shift Hours') and a ...
Need Help
  • ellynneu's avatar
    ellynneu
    2 years ago

    I figured it out! I had to call the parameter values as the variables.

    I used the following measure:

    Var sone = SELECTEDVALUE('577_1Active'[577_1Active])
    Var stwo = SELECTEDVALUE('577_2Active'[577_2Active])
    Var sthree = SELECTEDVALUE('577_3Active'[577_3Active])
    Var sfive = SELECTEDVALUE('577_5Active'[577_5Active])
    return
    if(sone=1&&stwo=1&&sthree=1&&sfive=1,360,0)



ellynneu's avatar
ellynneu
New Member
2 years ago

I figured it out! I had to call the parameter values as the variables.

I used the following measure:

Var sone = SELECTEDVALUE('577_1Active'[577_1Active])
Var stwo = SELECTEDVALUE('577_2Active'[577_2Active])
Var sthree = SELECTEDVALUE('577_3Active'[577_3Active])
Var sfive = SELECTEDVALUE('577_5Active'[577_5Active])
return
if(sone=1&&stwo=1&&sthree=1&&sfive=1,360,0)