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.

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.