Sum independent of selection

[#1]

Hi,

I'm trying to display a gauge that shows Sales up to Target of the current month, regardless of any selection done by the user. I created a nice expression for it, but something must be wrong, since it doesn't seem to work. When I select another month, the gauge changes, which should not be the case.

What I have is a variable that holds the Month and Year, like this:

Let vMonthYear = MonthName(Today());

I have loaded a field called MonthYear that is derived from the sales date. Another field holds the sales amount. I thought the expression for the gauge should be as follows:

Sum({<MonthYear={"$(vMonthYear)"}>} Sales)

Hopefully someone can help out.

Thanks!

[#2]

hi,

in your expression qv uses the current selection.

try this one:

Sum({<MonthYear=, MonthYear={"$(vMonthYear)"}>} Sales)

[#3 · Accepted solution]

Hi

Try this one please

Sum({1<MonthYear={"$(vMonthYear)"}>} Sales)

The 1 means that it does not look to other selections.

[#4]

This one works!

Thanks for the extremely quick reply!

[#5]

Hi Frank,

Thanks for the suggestion. It does not seem to work though 😞