var multiple value

[nicolast29]

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)

[v-yalanwu-msft · Accepted solution]

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.

[Jayee]

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]

Hi

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