Forum Discussion
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)
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.
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!!
Hi
This was how i did it in the past, but i wanted to improve with variable