List Box Help Needed

[Ankhi]

Hi All,

I need a help on creating a list box on a Measure value. 

I have the below table. There are many other measures and dimensions. For sample I have just given 3.

Project Number   Project Type  Available Budgets

1234                             T                         6000

4321                             T                        -5000

The available budget measure is a expression shown below. I would like to have a list box which will have values like 

'Overbudget Projects' and on selecting that value will only show me the projects that are in overbudgets range . In this case 4321 with -5000

I was trying with something like this . The variable contains the same Available Budget Expression. but it is not working.

=IF($(VOverBudget) < 0 ,'Over Budget Projects',null())

Available Budget Expression

Sum ({$<
Type = {'Budget'},
Month =,
FY Year =,
[Budget Type] = {'CBT'},
[Budget End Date] = {"<=$(=(YearEnd(AddMonths(today(),24))))"}
>}
Amount)

-

Sum ({$<
Type = {'Act'},
Month =,
FY Year =
>}
Amount)

Thanks in advance.

Regards

Ankhi

[rwunderlich · Accepted solution]

=Aggr( IF($(VOverBudget) < 0 ,'Over Budget Projects',null()), [Project Number])

-Rob

[Ankhi]

Thanks a lot @rwunderlich  . It worked.