Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone, apologies if this has been answered previously.
I joined a new project and am having trouble understanding what a dollar sign in between the first curly brace and carrot in the expression does. I understand what it means when used with a variable or formula, determines if the variable/formula is evaluated before the expression. But I'm not sure how that would work in this context. Here's an example:
num(
sum({$<Company={'Company A'},WeekEnding={'$(vMaxWeek)'}>}[Net Sales])
,'$#,##0)
What would be the difference between the above expression and this expression (removed the first $):
num(
sum({<Company={'Company A'},WeekEnding={'$(vMaxWeek)'}>}[Net Sales])
,'$#,##0)
Thanks
Hi @QuestionAndAnswer ,
No difference, put a dollar sign or let it blank is the same. Dollar $ for a set analysis means "for the active selections" to refer to your filters. The opposite for dollar-sign is 1 that means "disconnect your expression from all active selections", the calculations are performed on whole data.
Regards.
Hi @QuestionAndAnswer ,
No difference, put a dollar sign or let it blank is the same. Dollar $ for a set analysis means "for the active selections" to refer to your filters. The opposite for dollar-sign is 1 that means "disconnect your expression from all active selections", the calculations are performed on whole data.
Regards.
That's what it seemed like to me as well. I saw no difference from taking it out or leaving it in, which further added to my confusion haha. Thanks for clarifying!
It has nothing to do with variables else it specified the default selection state. Within the most cases there is no difference between applying the {$< and without the $-sign but there are some very specific scenarios which would return different results. I'm not sure if it's covered within the following - but even if not it's a good starting point to the use of set analysis: