Counting current month totals in Set Analysis Expression

[ZoeM]

Hi Community.

I have planned sales data in a monthly line chart from Jan to Dec.

I have the following expression and what I am trying to accomplish is to have a data point that shows the monthly total and changes as we go from month to month:

Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'},Date={$(=Date(Today(),'MMMM'))}>}Gateways)

I am getting zero when I throw the equation in a text box.

any help rendered will be truly appreciated. 

[dplr-rn]

Sample app would be ideal Or can you share pictures of what you are getting and dimensions and measures used.
Only 1 measure on your line chart right?
Also try copy pasting the count expression onto a text field. and check if value makes sense

[ZoeM]

[ZoeM]

Unfortunately I cannot share the app, even after scrambling, due to confidential restrictions. 

[dplr-rn]

If You have other expressions i believe it will interfere with the set analysis

[ZoeM]

I disabled the other expressions and still didn't work. So not too sure if that would help. 

[ZoeM · Accepted solution]

I think I got it...

I will have to check tomorrow to see if the month will change to December, but thus far I am able to show as intended:

Dual('Current Month, '& Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'},[Month of Year Abbreviated Name]={$(=Date(Today(),'MMM'))}>}Gateways),
Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'},[Month of Year Abbreviated Name]={$(=Date(Today(),'MMM'))}>}Gateways) )