Variables inside Set Analysis

[bkn]

I have a variable which store expression. I need to use that variable in Set Analysis.

Variable = vData

Eg.  =SUM({<Account={"Prime"}>}vData) // this does not work

[MK_QSL]

Try '$(vData)'

[Anonymous]

It depends what the expression is inside the variable.  If it contains an aggregation (e.g. sum or count), you have sum( of sum()), which is not allowed.  You have to use aggr:

sum(aggr(sum(),fields))

In your case probably something like this:

SUM({<Account={"Prime"}>} aggr(vData,<list of fields here>) )

[bkn]

DOES NOT WORK

[bkn]

What fields will be here <list of fields here>

[Anonymous]

This is something I cannot guess - it is specific to your application and the chart.  If you can upload your app or a simplified example, then I (or someone else) will be able to help.

[vvvvvvizard]

try just =$(vdata)

[bkn]

=NUM((SUM({<[ID]={"=Rank(Aggr(SUM([Current Quarter]),[ID]))<=20"}>} $(vData))),'$#,##0')

Sorry, doesnot work!!!

[ramoncova06]

what is inside of you variable ?

once you provide that we can understand what can be causing the problem

[bkn]

These expressions are inside variable:

If(UnbilledMonthName='FEB', SUM({<UnbilledMonthName={'NOV'},UnbilledFYYear={'$(vFYCurrentYear)'}>}[Unbilled Current Quarter])

,If(UnbilledMonthName='MAR', SUM({<UnbilledMonthName={'DEC'},UnbilledFYYear={'$(vFYCurrentYear)'}>}[Unbilled Current Quarter])

,If(UnbilledMonthName='APR', SUM({<UnbilledMonthName={'JAN'},UnbilledFYYear={'$(vFYCurrentYear)'}>}[Unbilled Current Quarter])

,If(UnbilledMonthName='MAY', SUM({<UnbilledMonthName={'FEB'},UnbilledFYYear={'$(vFYCurrentYear)'}>}[Unbilled Current Quarter])

,If(UnbilledMonthName='JUN', SUM({<UnbilledMonthName={'MAR'},UnbilledFYYear={'$(vFYCurrentYear)'}>}[Unbilled Current Quarter])

,If(UnbilledMonthName='JUL', SUM({<UnbilledMonthName={'APR'},UnbilledFYYear={'$(vFYCurrentYear)'}>}[Unbilled Current Quarter])

,If(UnbilledMonthName='AUG', SUM({<UnbilledMonthName={'MAY'},UnbilledFYYear={'$(vFYCurrentYear)'}>}[Unbilled Current Quarter])

,If(UnbilledMonthName='SEP', SUM({<UnbilledMonthName={'JUN'},UnbilledFYYear={'$(vFYCurrentYear)'}>}[Unbilled Current Quarter])

,If(UnbilledMonthName='OCT', SUM({<UnbilledMonthName={'JUL'},UnbilledFYYear={'$(vFYCurrentYear)'}>}[Unbilled Current Quarter])

,If(UnbilledMonthName='NOV', SUM({<UnbilledMonthName={'AUG'},UnbilledFYYear={'$(vFYPriorYear)'}>}[Unbilled Current Quarter])

,If(UnbilledMonthName='DEC', SUM({<UnbilledMonthName={'SEP'},UnbilledFYYear={'$(vFYPriorYear)'}>}[Unbilled Current Quarter])

,If(UnbilledMonthName='JAN', SUM({<UnbilledMonthName={'OCT'},UnbilledFYYear={'$(vFYPriorYear)'}>}[Unbilled Current Quarter])))))))))))))