Calling a Month to Num in Set Analysis

[nathan_roadshow]

Hi all,

I'm trying to return a sales by month on the basis as below:

If Calendar_Num (6,7,8) = Calendar Month variable, return the Net Sales for that

Sum({<Calendar_Num={"$(vCalendarMonth)"}>}[Net Sales Units])

However this returns 0, any idea why?

[Taoufiq_Zarra]

@nathan_roadshow  can you share a sample data and the expected output

[nathan_roadshow]

Hi @Taoufiq_Zarra ,

Please see below:

For example, I would like to return the Month's sales based on the month.

For example, my variable is = Num(Month(Today())).

In the table,  this does not return the sales for NET sales.

--- Sum({<Calendar_Num={'5'}>}[Net Sales Units]) ----

For example, Sum({<[Material Desc]={'A Star is Born'},[=If(Num(Month(Today()))=Calendar_Num,'Y','N')]={'Y'}>}
[Net Sales Units]) will return the sales. But the above does not.

See below.