Sum of days with selected value and swicth

[eliasayyy]

hello everyone i have a date timeline slicer and i have measure

test measure = 
VAR _days =
SWITCH(
    SELECTEDVALUE(Test[Month Number]),
     1 ,31,
     2,28,
     3,31,
     4,30,
     5,31,
     6,30,
     7,31,
     8,31,
     9,31,
     10,31,
     11,30,
     12,31
)
RETURN
_days

if i select one value it works and returns day but if i select 2 months, it will return blank how do i add them?

[tamerj1 · Accepted solution]

Hi @eliasayyy 

test measure =
SUMX (
VALUES ( Test[Month Number] ),
SWITCH (
Test[Month Number],
1, 31,
2, 28,
3, 31,
4, 30,
5, 31,
6, 30,
7, 31,
8, 31,
9, 31,
10, 31,
11, 30,
12, 31
)
)