Forum Discussion

saivina2920's avatar
saivina2920
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

How do we call variables in DAX measure

I am using below measure and i just want to call the variables.   variables ==> need to get from slicer/dropdown or any selected controls/chart values.   How do we assign controls/chart values in...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi saivina2920 ,

     

    Please try this.

    EMPSTATUS = 
VAR variables = SELECTEDVALUE('EMP QUERY'[EMP_PLACE])
RETURN
CALCULATE(
    DISTINCTCOUNT ( 'EMP QUERY'[EMP_NUMBER] ),
    FILTER(
        ALL('EMP QUERY'),
        'EMP QUERY'[EMP_REMARKS] in { "GOOD", "EXCELLENT"} &&
        'EMP QUERY'[EMP_COUNTRY] = "INDIA" &&
        'EMP QUERY'[EMP_PLACE] = variables
    )
)

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi saivina2920 ,

 

Please try the formula.

EMPSTATUS = 
VAR variables = SELECTEDVALUE('EMP QUERY'[EMP_PLACE])
RETURN
CALCULATE(
    DISTINCTCOUNT ( 'EMP QUERY'[EMP_NUMBER] ),
    FILTER(
        ALL('EMP QUERY'),
        'EMP QUERY'[EMP_REMARKS] = "GOOD" &&
        'EMP QUERY'[EMP_COUNTRY] = "INDIA" &&
        'EMP QUERY'[EMP_PLACE] = variables
    )
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

saivina2920's avatar
saivina2920
Icon for Post Prodigy rankPost Prodigy
5 years ago

Thanks again for your great help.

Shall i use the below condition if more than two values.

'EMP QUERY'[EMP_REMARKS] in ("GOOD","EXCELLENT")

 

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi saivina2920 ,

     

    Please try this.

    EMPSTATUS = 
VAR variables = SELECTEDVALUE('EMP QUERY'[EMP_PLACE])
RETURN
CALCULATE(
    DISTINCTCOUNT ( 'EMP QUERY'[EMP_NUMBER] ),
    FILTER(
        ALL('EMP QUERY'),
        'EMP QUERY'[EMP_REMARKS] in { "GOOD", "EXCELLENT"} &&
        'EMP QUERY'[EMP_COUNTRY] = "INDIA" &&
        'EMP QUERY'[EMP_PLACE] = variables
    )
)

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • saivina2920's avatar
      saivina2920
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      Perfect. One last question.

      How to exclude selected value like not in selected value in the measure.

      VAR variables = SELECTEDVALUE('EMP QUERY'[EMP_PLACE])

       

       if this NOT IN selected value, then my problem is solved.

      • NandanHegde's avatar
        NandanHegde
        Icon for Super User rankSuper User
        5 years ago

        You can leverage the NOT operator

         

        NOT('EMP QUERY'[EMP_REMARKS]) IN { variables}

  • NandanHegde's avatar
    NandanHegde
    Icon for Super User rankSuper User
    5 years ago

    Hey saivina2920 
    Sorry for the delayed response as I was on some medical leave.
    The above answer provided by CST is accurate but for using IN operator you should use {} and not ()