Forum Discussion

nicolast29's avatar
nicolast29
Helper V
3 years ago
Solved

var multiple value

Hi

How to use a var with multiple values ?

 

Example:

CA DPH =
Var Section = 6 or 7,8,9
Return
CALCULATE(SUM(CAHebdo[CA]),CAHebdo[SectionAbaco]=Section)
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, nicolast29 ;

    Do you mean that dynamic changes based on slicer changes? If yes, you can try:

    Measure = 
CALCULATE(SUM('Table 2'[Value]),FILTER('Table 2',[Value] in  VALUES('Table'[Value])))

    The final show:

    If not, can you share a simple data and result what you want to output?


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Jayee's avatar
    Jayee
    Responsive Resident
    3 years ago

    Hi nicolast29 ,

     

    Try below measure

     

    CALCULATE(SUM(CAHebdo[CA]),CAHebdo[SectionAbaco] in {6,7,8,9})

     

    If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

    • nicolast29's avatar
      nicolast29
      Helper V
      3 years ago

      Hi

      This was how i did it in the past, but i wanted to improve with variable

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, nicolast29 ;

    Do you mean that dynamic changes based on slicer changes? If yes, you can try:

    Measure = 
CALCULATE(SUM('Table 2'[Value]),FILTER('Table 2',[Value] in  VALUES('Table'[Value])))

    The final show:

    If not, can you share a simple data and result what you want to output?


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.