Forum Discussion

hnguyen76's avatar
hnguyen76
Resolver II
5 years ago

Conditional Filter On Different Tables

Hi All. I have an optimization question. Currently I have a measure that returns the correct values in which I'm looking for. The measure is as followed: VAR _DateFilter = DATESBETWEEN(Dim_Calen...
Need Help
ImkeF's avatar
ImkeF
Community Champion
5 years ago

Hi hnguyen76 ,
your code will probably work if you replace the Blank()  (which returns a scalar value) by an empty table {} :

 

VAR _FilterCriteria = // Of course, this does not work
SWITCH( _SelectedValue,
"AB", ALL(Dim_PL_Hierarchy),
"CB", ALL(Dim_Geo_Hierarchy),
"ZY", {}
)